one tree, two paths: my SQL hierarchy dilemma

A few weeks ago, I was working on a project that needed to manage a pretty deep hierarchy of users, something like: Admin → Operation Lead → DPR Head → DPR → LPR Head → LPR → Volunteers At first, it seemed like your classic parent_id setup. Nothing...