--获取所有父节点的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
)
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
)