sql层级数据查询

WITH t AS ( 
SELECT * FROM Sys_Basic_Project_Category_Tree WHERE ID = 2 
UNION ALL 
SELECT a.* FROM Sys_Basic_Project_Category_Tree a 
JOIN t b ON a.Parent_ID = b.ID 
) 
SELECT ID FROM t WHERE ID<>2


通过上述sql语句，可以查询到Id=2的节点的所有子节点列表信息。