Rex的博客

递归查找所有孩子节点，包括当前节点--查找当前用户所在部门的所有下级包括当前部门with children as( select ObjectId,Pid,Name, 0 as lvl from SysStruct where ObjectId = 2 union all select d.ObjectId,d.Pid,d.Name,lvl + 1 from children c inner join SysStruct d on c.ObjectId = d.