gistfile1.sql

WITH RECURSIVE descendants(id, active, name, longname, parent_id, reseller, created_at, updated_at, uuid) AS (
  SELECT * FROM client WHERE {conditions...}
    UNION
  SELECT client.* FROM client, descendants WHERE client.parent_id = descendants.id
)
SELECT * FROM descendants

-- OR --

SELECT * FROM clients WHERE id IN (
  WITH RECURSIVE descendants(id, parent_id) AS (
    SELECT id, parent_id FROM clients WHERE {conditions...}
      UNION
    SELECT clients.id, clients.parent_id FROM clients, descendants WHERE clients.parent_id = descendants.id
  )
  SELECT id FROM descendants
);