Use of SQL Server with recursive queries

1. Data preparation
Suppose there is a table Digui, there are two field IDs int ParentID int
Id ParentID
40
50
70
21st
85
155
97
1411
3015
2315
4118
10423
4230
3930
5339
6739
8839
10739

2. Purpose: By passing in ParentID (=5), all recursive data of the record is returned, i.e.
Id ParentID
85
155
3015
2315
4230
3930
5339
6739
8839
10739

3. SQL Statement Implementation

 with Temp([Id],[ParentID]) as(SelectId, ParentID fromDiguiwhere [ParentID] =  theUnion  AllSelecta.id, A.parentid fromDigui aInner Join Temp  onA.[ParentID] = Temp.[Id])Select *  from Temp