Recursive CTE란?

Recursive CTE

WITH RECURSIVE tree AS (
  SELECT id, parent_id FROM nodes WHERE id=1
  UNION ALL
  SELECT n.* FROM nodes n JOIN tree ON n.parent_id=tree.id
) SELECT * FROM tree;