Data modeling qustion

I have a user record database which has
employee, userinfo1, userinfo2, managername
foo1, info1, info2, foo2
foo2, info1, info2, foo3
foo3, info1, info2, foo4

as now I have
manager level foo4 -> foo3 -> foo2 -> foo1

foo1 has three manger on top of him

how do I setup data model so every employee has manager and his manager and his manger all the way to top.

that way when I search for foo4 I get every employee under him and not just direct report employee.

is this possible?

I do not control how data is created on other end (mysql database)
I just have permission to pull that data

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.