Complex relations in database (with Laravel)
<p>I want to know how to make relations between tables:</p>

<p>I have a <code>shops</code> table and a <code>users</code> table.<br>
I want to associate to the <code>users</code> table: shops (id) AND area (that's a group of shops).<br>
I don't know how to do that in a beautiful and right way.</p>

<p>For example, in a very complex way we can have:</p>

<p>Area A contains [Area B (3 shops) and Area C (1 shop)] and 1 shop : total of 5 shops.<br>
John is associate to the Area A, Area X and 3 other shops (no area).</p>

<p>How to represent this in database?
It's like a recursive thing :(</p>

<p>Thanks by advance!</p>