递归获取父级

with Temp
as
(
    select * from fw_Departments where   id = '383c38938cc94983acdc1e2eb981b6d7'
    union all
    select fw_Departments.* 
    from Temp join fw_Departments on Temp.ParentId = fw_Departments.Id
)
select * from Temp

递归获取所有子级

with Temp
as
(
    select * from fw_Departments where   id = '383c38938cc94983acdc1e2eb981b6d7'
    union all
     select fw_Departments.* from Temp join fw_Departments on fw_Departments.ParentId=Temp.Id
)
select * from Temp