```sql
WITH RECURSIVE child (id, title, description, parent_id) AS
(
  SELECT id, title, description, parent_id
    FROM items
    WHERE id = 38
  UNION
  SELECT parent.id, parent.title, parent.description, parent.parent_id
    FROM child JOIN items as parent
      ON child.parent_id = parent.id
)
SELECT * FROM child;
```

https://www.mysqltutorial.org/mysql-adjacency-list-tree/

## JS Libraries

- https://github.com/dbushell/Nestable
  - https://dbushell.github.io/Nestable/
- https://sortablejs.github.io/Sortable/
- https://bevacqua.github.io/dragula/