Recursive CTE

How to Query a Category Tree in PostgreSQL with a Recursive CTE

In a PostgreSQL category table, each category can store its parent’s ID in the same table. To get a category and all the categories below it, PostgreSQL follows…