SELECT all the children of a row and concat
For those who encountered the same problem. I did not answer this but someone provided the answer, I'll leave the link here: https://stackoverflow.com/questions/52773824/recursive-query-in-oracle-to-find-children-and-sibling/52776124#52776124