列的T-SQL条件移位

I currently have a union of two SQL queries that results in the entirety of the organizational chart for my business. The query is as follows:I currently have a union of two SQL queries tha