with cte as(
select bianma,fjbm from #tree where chkDisabled='true'
union all
select t.bianma,t.fjbm from cte c inner join #tree t on c.fjbm=t.bianma
)
select * from cte;
2021-12-19 22:17:24
with cte as(
select bianma,fjbm from #tree where chkDisabled='true'
union all
select t.bianma,t.fjbm from cte c inner join #tree t on c.fjbm=t.bianma
)
select * from cte;