select
dept_id,
dept_name as name ,
parent_id as pid,
case
when exists(
select
1
from
sys_dept t2
where
a.dept_id = t2.parent_id) then 0
else 1
end as leaf
from
sys_dept a
