WITH DeptTree AS
(
SELECT PK_ID from IBP_T_Department where PK_ID = 158--需要查找的节点
UNION ALL
SELECT IBP_T_Department.PK_ID from
WITH DeptTree AS
(
SELECT PK_ID from IBP_T_Department where PK_ID = 158--需要查找的节点
UNION ALL
SELECT IBP_T_Department.PK_ID from