sql server递归

1with cte as
2(
3select belongsAgent from [QPProxyDB].[dbo].[BS_ProxyInfo] where ProxyID = @ProxyID 
4union all
5select a.ProxyID from [QPProxyDB].[dbo].[BS_ProxyInfo] a join cte b on a.ProxyID = b.belongsAgent
6)
7select * from cte order by belongsAgent asc
8
9ProxyID 父级
10
11belongsAgent 子集