By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| ParentUID | ChildUID | Depth |
|---|---|---|
| 22 | 1 | 0 |
| 22 | 2 | 0 |
| 22 | 3 | 0 |
| 22 | 4 | 0 |
| 22 | 5 | 0 |
| 22 | 6 | 0 |
| 22 | 7 | 0 |
| 333 | 22 | 1 |
| 4444 | 333 | 2 |
| 55555 | 4444 | 3 |
| 666666 | 55555 | 4 |
11 rows affected
| ParentUID | ChildUID | Depth |
|---|---|---|
| 22 | 1 | 0 |
| 22 | 2 | 0 |
| 22 | 3 | 0 |
| 22 | 4 | 0 |
| 22 | 5 | 0 |
| 22 | 6 | 0 |
| 22 | 7 | 0 |
| 333 | 22 | 1 |
| 4444 | 333 | 2 |
| 55555 | 4444 | 3 |
| 666666 | 55555 | 4 |