SQL递归查询

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