How to organize such a hierarchy in Laravel?

Question

Laravel

There are the following tables:
-refcodes (id)
-promos (id)
-refcodes_promos (refcode_id, promo_id)

The third one is intermediate, linked via

belongsToMany »

And finally display the following hierarchy:

Refcode 1
- promo 1
- promo2
- promo3
Refcode 2
- promo 2 - promo
4 - promo
5

Answer 1

If a promo can have a sub-promo, then enter a parent_id field in the promos table showing the promo's parent.