sql查询父节点下的子节点的用户（包括父节点的用户）

with myT as(
select id ,parent_id from organization
),
myT2 as(
select * from myT where parent_id in(#{upperId})
union all
select myT.* from myT2 inner join myT 
 on myT2.id=myT.parent_id
)
select u.id from myT2 t
join [user] u on t.id=u.upper_id
union all 
select id from [user] where id=#{userId}

 

转载于:https://www.cnblogs.com/jackszc/p/11339715.html