Why 2 separate MySQL query for relationship?

[Uttam-EWW]

Why 2 separate MySQL query for relationship?
User Model:

UserGroup Model:

when I execute await user.related('inGroups').query().preload('group'); why 2 separate SQL queries are being executed?

[Uttam-EWW]

@thetutlage Really sorry for tagging you here but I really need to know why it is happening. Please let us know what's going on here.

[Barbapapazes]

Can you explain more what is UserGroup ? Is-this a model to link a user and a group ?

[Uttam-EWW]

yes.

[Barbapapazes]

First, I think you should take a look to a many to many relationship. In fact, UserGroup is just a pivot table and a migration is enough, no model is needed!

Then, I didn't try but I think related is one and preload is another and then Lucid will set then on the correct instance!

Maybe you can expected only one using many to many relationship!