By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
lvl | member | parent |
---|---|---|
1 | Group-D | null |
2 | Group-C | Group-D |
2 | User-5 | Group-D |
3 | Group-A | Group-C |
3 | Group-B | Group-C |
4 | User-1 | Group-A |
4 | User-2 | Group-A |
4 | User-3 | Group-B |
4 | User-4 | Group-B |
lvl | member | parent |
---|---|---|
1 | Group-D | null |
1 | Group-E | null |
2 | Group-C | Group-D |
2 | User-5 | Group-D |
2 | User-6 | Group-E |
3 | Group-A | Group-C |
3 | Group-B | Group-C |
4 | User-1 | Group-A |
4 | User-2 | Group-A |
4 | User-3 | Group-B |
4 | User-4 | Group-B |