SQL SERVER 树结构查询

with subqry as (
select * from t_process 
WHERE business_id = '1fe6c42f373a4571b993df94989d9b87'
union all
select t_process.* from t_process,subqry
where t_process.parent_id = subqry.id
)
select * from subqry;