By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 6 Duplicates: 0 Warnings: 0
| id | name | lvl | parentid | name |
|---|---|---|---|---|
| 1 | categ 1 | 0 | 0 | null |
| 5 | categ 2 | 0 | 0 | null |
| 3 | acateg 1.2 | 1 | 1 | categ 1 |
| 2 | xcateg 1.1 | 1 | 1 | categ 1 |
| 4 | categ 1.2.1 | 2 | 3 | acateg 1.2 |
| 6 | categ 2.1 | 1 | 5 | categ 2 |