Recursive ancestors query for PostgreSQL

ancestors.sql

WITH RECURSIVE ancestors(id, name, created_at, updated_at) AS (
    SELECT categories.id, categories.name, categories.created_at, categories.updated_at
    FROM categories, categorizations
    WHERE categorizations.subcategory_id = '667C9DF5-48C0-496B-922A-1B7D743B1A39'
      AND categories.id = categorizations.category_id
  UNION ALL
    SELECT categories.id, categories.name, categories.created_at, categories.updated_at
    FROM categories, categorizations, ancestors
    WHERE categorizations.subcategory_id = ancestors.id
      AND categories.id = categorizations.category_id
)
SELECT * FROM ancestors