Our database system requires a hierarchy of users like so:
A
/ \
B C
/ \ / \
d e f g
/\
h i

User B can see/edit records allocated to B, d, e, h and i, but cant see any others. User d can see records allocated to them, h and i only, and so on.

How would you set this up in a database?