How to get data from many to many relationship

Assuming you setup the relationships in the Eloquent, try this:

I don't actually know if that would work for sure, but give it a try.

$companies = Company::whereNotNull('businessclub_id')->whereHas('activities', function($query) {
    // $query->wherePivot('countrycode', 'ml'); // Apparently this doesn't work
    $query->where('countrycode', 'ml'); // But this does
})->get();

Thanks for answering back. It is not working, here is the error im getting SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pivot' in 'where clause' (SQL: select * from companies where businessclub_id is not null and exists (select * from activities inner join activity_company on activities.id = activity_company.activity_id where companies.id = activity_company.company_id and pivot = countrycode))

It is working now, with this code: $query->where('countrycode', 'ml'); instead of $query->wherePivot('countrycode', 'ml');

Thanks for your help, But what if I want to retrieve and display a data from both table EXAMPLE:

$BM=Company::whereNotNull('businessclub_id')->whereHas('activity', function($query) { $query->where('countrycode','=','ml'); })->get();

@foreach ($BM as $BMS)

<a class="label label-primary" href="#">{{$BMS->activity->name}}</a>
<h3><a href="#">{{$BMS->name}}</a></h3>
                                

@endforeach

I am getting this Error: "Property [name] does not exist on this collection instance. (View: C:\Users\KEITA\ibafrica\resources\views\homes\index.blade.php)" and it is related to this {{$BMS->activity->name}}

@hakan

Use ``` before starting and after ending your code to make your code readable.

OK TISUCHI, let me give a try

I want to retrieve and display a data from both table EXAMPLE:

$BM=Company::whereNotNull('businessclub_id')->whereHas('activity', function($query) { $query->where('countrycode','=','ml'); })->get();
@foreach ($BM as $BMS)
<a class="label label-primary" href="#">{{$BMS->activity->name}}</a>
<h3><a href="#">{{$BMS->name}}</a></h3>                             
@endforeach 

I am getting this Error: "Property [name] does not exist on this collection instance." and it is related to this {{$BMS->activity->name}}

$company->activity->name wont work because a single company can have more than one activity. Knowing that:

$company->activity; // returns a collection of activity models
$company->activity->first(); // Gets you the first activity of the company

The relation should be called activities, instead of activity, to avoid being missleading.

That worked! Thank you so much! Your explanation was perfect!