Infinite structure SQL queries all subordinates and all subordinates

ID,PID infinite structure, querying all subordinates or all ancestors of an ID, using with AS

Look for subordinates with ID 1

/* Find all subordinates with Id 1 */with T as (      SELECT id,pid,name,0 L from User WHERE id=1     UNION all      Select U.id,u.pid,u.name , l+1 from        User U INNER JOIN T in u.pid=t.id   )  SELECT * from T

Find all superiors with ID 100

/* Find all ancestors with Id 100 */with T as (      SELECT id,pid,name,0 L from User WHERE id=100     UNION all      SELECT u.id,u.pid, U.name,l+1 from the        User U INNER JOIN t on u.id=t.pid   )  SELECT * from T

Infinite structure SQL queries all subordinates and all subordinates