SQL Server:如何将CTE递归限制为只是递归添加的行？

WITH EmployeeCTE (EmployeeID, FirstName, LastName, JobTitle, RecursionLevel)
AS
(
    -- 基本查询：选择起点
    SELECT e.EmployeeID, e.FirstName, e.LastName, e.JobTitle, 0 AS RecursionLevel
    FROM Employees AS e
    WHERE e.EmployeeID = 1 -- 指定起点

    UNION ALL

    -- 递归查询：选择下一级
    SELECT e.EmployeeID, e.FirstName, e.LastName, e.JobTitle, EmployeeCTE.RecursionLevel + 1 AS RecursionLevel
    FROM Employees AS e
    INNER JOIN EmployeeCTE
    ON e.ReportsTo = EmployeeCTE.EmployeeID
    WHERE EmployeeCTE.RecursionLevel < 2 -- 限制递归的深度
)

-- 查询结果
SELECT EmployeeID, FirstName, LastName, JobTitle, RecursionLevel
FROM EmployeeCTE
ORDER BY RecursionLevel, FirstName, LastName;