SQL - 如何从路径列解析层次结构级别

I am trying to represent hierarchical data through an API, and am looking for a solution I could implement on the SQL side (the procedure that is called from the API). I have a column that represents a trace (an 'ID_Path') from the highest parent down to it's children, and am trying to order from an item in the branch downward.I am trying to represent hierarchical data thro