Organization Chart Practical Recursive CTE in SQL

Let’s create an Organization Chart with SQL Server like this

Here is the table i created to enjoy recursive CTE.

we just need this script

to get this result

How it works?

i took this graphic from https://www.sqlservertutorial.net/sql-server-basics/sql-server-recursive-cte/

Variable declaration

If you like to test those expamples here are the scripts.
https://github.com/xeneous/CTERecursiveExplained

After getting the initial query results, recursion appears under the union all comment