Query for the parent node of the SQL Server tree structure Data child node

Declare @t table (c_id int,pcname varchar (6), ParentID int)
INSERT INTO @t
Select 1, ' Anhui ', 0 union ALL
Select 2, ' Anqing ', 1 UNION ALL
Select 3, ' Anqing ', 2 UNION ALL
Select 4, ' Huaining County ', 2 UNION ALL
Select 5, ' Qianshan County ', 2 UNION ALL
Select 6, ' Susong County ', 2 UNION ALL
Select 7, ' Taihu County ', 2 UNION ALL
Select 8, ' Tongcheng ', 2 UNION ALL
Select 9, ' Wangjiang County ', 2 UNION ALL
Select 10, ' Yuexi County ', 2 UNION ALL
Select 11, ' Congyang County ', 2

; with Maco as
(
SELECT * FROM @t where c_id=11
UNION ALL
Select t.* from @t t,maco m where T.c_id=m.parentid
)
SELECT * from Maco ORDER by c_id

/*
c_id Pcname ParentID
----------- ------ -----------
1 Anhui 0
2 Anqing 1
11 Congyang County 2
*/

Query for the parent node of the SQL Server tree structure Data child node