后端查询树的通用SQL，具备懒加载功能

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') --根据传入的父节点查询所有一级子节点

转载于:https://www.cnblogs.com/cdblogs/p/7895469.html