WITH deps AS
    (
        SELECT r.ID,
               ru.UserID,
               r.ParentID,
               r.TypeID
        FROM RoleUsers ru WITH (NOLOCK)
        INNER JOIN Roles r WITH(NOLOCK)
            ON r.ID = ru.ID
        INNER JOIN DepartmentRoles dr WITH(NOLOCK)
            ON dr.ID = r.ID
        WHERE ru.UserID = '3db19fa0-228a-497f-873a-0250bf0a4ccb'
        UNION ALL
        SELECT d.ID,
               d.UserID,
               d.ParentID,
               d.TypeID
        FROM deps d
        JOIN Roles r WITH(NOLOCK)
        ON r.ParentID = d.ID
    )
SELECT * FROM deps

[23000][530] The statement terminated. The maximum recursion 100 has been exhausted before statement completion.