declare @account nvarchar(20)
set @account = 'XXX' ;--查询人员的账号
WITH percte AS
(SELECT id, managerid,loginid,lastname --, 0 AS lv1
FROM HrmResource
WHERE loginid in (@account)
UNION ALL
SELECT c.id, c.managerid,c.loginid,c.lastname --, p.lv1 + 1 AS Expr1
FROM percte AS p
JOIN HrmResource AS c ON c.managerid = p.id)
SELECT lastname,id --, lv1
FROM percte --AS percte_1
查询某个员工的所有下级,用于权限控制