Sql Server中通过父记录查找出所有关联的子记录

可查级Sql代码

select menu_idmenu_nameFather_Id from Sys_Menu where menu_id= or Father_Id= or 一级二级Father_Id in (select menu_id from Sys_Menu a where menu_id= or Father_Id=) or 三级father_id in (select menu_id from sys_menu where Father_Id in (select menu_id from Sys_Menu a where menu_id= or Father_Id=)) 四级