我应该怎样来实现这个目标

I am in kind of situation where I don't know where to go. I have to write a query such that it is kind of hierarchical. I am in kind of situation where I don't know wh