Doubt with hierarchical data

Question

Talk, you guys, all right ?

I have a problem already have a few days , in the system I need to control the display of some data, I have a function registration , sector and employee, linked between yes. In this business rule, the User can assemble his sector and soon his hierarchy in a dynamic way , thus , Users can only see their data and if they are responsible for someone, this responsible person can see the data of his subordinate and the data of his subordinate and so on.

In this table above I can know who is responsible for whom and so I can have a hierarchical line.

My problem is in being able to do this scale , knowing who is responsible for who and if this person who is subordinate is responsible for someone tb , so the first responsible person can see the data of the second responsible and see the data is subordinate to that responsible. Does anyone know a way to do this? What if this is the best way to store those responsible (Hierarchy)

OBS: in the column responsavel_titular and responsavel_subordinado are the employee codes.