SQL Server with as bidirectional recursion

Recursive subordinate departments to obtain relevant departmental units

1. Department Table:
2. SQL statements:

   With Temp1 as (select Groupid,g_parentid from Sys_group  where groupid={current department groupid}union Allselect Sys_ Group.groupid,sys_group.g_parentid from TEMP1  inner joins Sys_group on Temp1.g_parentid=sys_group.groupid   ), TEMP2 as (select Groupid,g_parentid from Sys_group  where groupid={current department groupid}union Allselect Sys_group.groupid, Sys_group.g_parentid from TEMP2  inner joins Sys_group on Temp2.groupid=sys_group.g_parentid  ) Select GroupID From  Temp1 Union  select GroupID from TEMP2

SQL Server with as bidirectional recursion