Is there a way to retrieve a parent child tree from a single table, with multiple roots and a child_order column? I have a table that looks like this:
