SQL Query - Hierarchical user structure

recursive.sql

WITH RECURSIVE subordinates AS (
   SELECT
      ur.user_id,
      ur.owner_id
   FROM
      users.user_roles ur
   WHERE
      ur.user_id = 87 --DESIRED USER ID
   UNION
      SELECT
         ur2.user_id,
         ur2.owner_id
      FROM
         users.user_roles ur2
      INNER JOIN subordinates s ON s.user_id = ur2.owner_id
) SELECT
   *
FROM
   subordinates;

TOP!