SQL Server 2005 CTE分层表，管理重复项，没有maxrecursion

The problem I am attempting to solve is a request to pull data from a table using a CTE to retrieve hierarchical data. Because of the nature of the data referencing itself, hitting max recursion is a huge problem but I don't want to arbitrarily stop the data because then it wouldn't be complete. To understand the data, here is what the sample output should look like: The problem I am attempting to solve is a reque