Tracking depth

Question

Tracking depth

Accepted Answer

The anchor selects Alice (the root, no manager) at depth 0. The recursive member finds Bob (manager_id = 1, Alice's id) and assigns depth 1. Next iteration finds Carol (manager_id = 2, Bob's id) at depth 2. Carrying a depth counter is the standard technique for knowing how many levels deep you are in the hierarchy. This is useful for indenting org charts or enforcing nesting limits.