There are a few different examples of this on here, but nothing quite like I need to do. I have a table in my DB with an ID, name and parent fields. I need to output this info in my ui but I am having trouble grouping them.
Query results:
ID Name Parent
100 Test NULL
101 Org1 NULL
102 Org2 101...