Maybe have a look at baum\nestedset package ;)
Here's an excellent article describing various hierarchical techniques, particularly when using a relational database such as MySQL. Regardless of the direction you take, read this article; it does a great job of explaining each technique with context.
Thanks for the replies.
As I said, I think that nested sets are a bit overkill, but it's always good to look over someone else's code.
Sign in to participate in this thread!
We'd like to thank these amazing companies for supporting us
The Laravel portal for problem solving, knowledge sharing and community building.