with dates as
(
select Id,Name from BaseData where Id = 5 --查询节点
union all
select a.Id,a.Name
from BaseData a join dates b on a.ParentId = b.id
where a.id is not null
)
select * from dates
(
select Id,Name from BaseData where Id = 5 --查询节点
union all
select a.Id,a.Name
from BaseData a join dates b on a.ParentId = b.id
where a.id is not null
)
select * from dates