查询某个员工的所用下级

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

　查询某个员工的所有下级，用于权限控制