例子:
select * from
sys_org
where
orgid
in (select
orgid
from
sys_org
start with
orgid
= '10000' connect by prior
sys_org.orgid
=
sys_org.sorgid
)
查询orgid=‘00000’的下级菜单,以及下下级(sys_org.orgid = sys_org.sorgid)