viewing permissions

[ynotlim]

Hello,

I need help w/ this type of "tree" programming. Has anyone done this before and can share their code? Thanks very very much in advance!

I have a db w/ table as follows:

columns:userid, user_supervisor(by userid)
1. john_doe1 , bob_doe3
2. bob_doe3, bob_doe3
3. debbie_liu, john_doe1
4. john_t, john_doe1
5. jane_2, john_t

I want to create a page that can comment on employers.
1. if bob_doe3 logs in, he can view everyones profiles.
2. if john_doe1 logs in, he can view john_t, debbie_liu, and jane_2's profile.

So you basically, you can view the ppl u supervise as well as the ppl that your ppl supervise.

thanks again,
Tony