select t.org_id as key, --key值
t.org_name as title, --标题
t.has_sub as folder, --是否显示文件夹
t.has_sub as lazy, --是否懒加载
t.orderby --排序
from (select d.*,
case
when s.parent_org_id ='00000000000000000000000000000000' then
0
else
1
end as has_sub
from sec_org d
left join (select t.parent_org_id
from sec_org t
group by t.parent_org_id) s
ON d.org_id = s.parent_org_id
where 1 = 1
and d.status = 'enable'
and d.parent_org_id ='00000000000000000000000000000000') --根据传入的父节点查询所有一级子节点