通用树状节点 获取所有叶节点和支节点 sql

--获取所有父节点的menu_item
select distinct  s1_parent.*  
from sys_menu s1_parent,sys_menu s2
where 1=1
and s1_parent.menu_id = s2.parent_id
--获取所有具体页面节点的menu_item
select s.*
from sys_menu s where s.menu_id not in
(select distinct  s1_parent.menu_id  
from sys_menu s1_parent,sys_menu s2
where 1=1
and s1_parent.menu_id = s2.parent_id
)