Many-to-many relationship joins do not use pivot table

[stoutput]

Describe the bug
When using .joins() or .join_on() on a table with a predefined belongs_to_many relationship, the resulting query does not join on the pivot table.

To Reproduce

1. Add a belongs_to_many relationship on a model:

   class Organization(Model):
       @belongs_to_many(
            local_foreign_key="organization_id",
            other_foreign_key="user_id",
            local_owner_key="organization_id",
            other_owner_key="id",
            table="organization_members",
            with_fields=["role"],
         )
         def members(self):
            from .user import User
            return User

2. Build a joins query:

   Organization.select('users.email').joins('members').where('id', "<some_id>").to_sql()

3. Note that the resulting SQL attempts to join directly to users:

   SELECT `users`.`email`
   FROM `organizations`
   INNER JOIN `users` ON `organizations`.`organization_id` = `users`.`user_id`
   WHERE `organizations`.`id` = '<some_id>'

Expected behavior
The resulting SQL should join to users through the defined relationship:

SELECT `users`.`email`
FROM `organizations`
INNER JOIN `organization_members` ON `organizations`.`organization_id` = `organization_members`.`organization_id`
INNER JOIN `users` ON `organization_members`.`user_id` = `users`.`id`
WHERE `organizations`.`id` = '<some_id>'

Desktop (please complete the following information):

• OS: OSX
• Version latest

What database are you using?

• Type: MySQL
• Version 5.7
• Masonite ORM 2.10

Additional Context
The clause arg in the .joins() method should change the second join type, since the pivot join should always be INNER

[Kaweechelchen]

Is it possible that the "with_fields" option is also not working?

Your expected behaviour should also list that field as a selected column, correct?

[josephmancuso]

It's possible. I think the issue here is that the BelongsToMany relationship is just not doing the relationship joining right.