你可以这样做：
WITH CTEAS( SELECt reviewer, reviewee FROM TableName WHERe reviewee = @revieweeID UNIOn ALL SELECt p.reviewer, p.reviewee FROM CTE c INNER JOIN TableName p ON c.reviewee = p.reviewer)SELECt * FROM CTE;--- WHERe reviewer = @reviewerID;
[演示版](https://data.stackexchange.com/stackoverflow/query/89270/recursive-
sql-server-query)
