摘要： -- 查找树的所有子节点 with cte as (select Id,Pid,Name from dc_trees where pid=2union allselect t.id,t.pid,t.Name from cte a,dc_trees t where t.pid=a.id)select 阅读全文