SQL父子 - 主祖父母层次结构

I have a table called LIST in the following format where in each row parents and childs are identified. There are multiple levels of childs I have a table called LIST in the following for