recursive1.sql

with recursive all_categories as (
  select * from categories where parent_id = 3
  union all
  select b.* from all_categories a, categories b where a.id = b.parent_id
) select * from all_categories order by parent_id;