Thanks @corkrean! Appreciate your help. We drew inspiration from this two-way relation pattern to build our final schema. Even though we need to manage more relations if we need to move hierarchies around, it's still way less than having users connected to every resource on every level, which was our last resort.