查找树的所有子节点

-- 查找树的所有子节点

with cte as

(select Id,Pid,Name from dc_trees where pid=2
union all
select t.id,t.pid,t.Name from cte a,dc_trees t where t.pid=a.id)
select * from cte