one tree, two paths: my SQL hierarchy dilemma
Jul 12, 2025 · 7 min read · 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...
Join discussion

