How to show data from two model with sum column eloquent Laravel

Question

i have two table with the following details:

Ecourse table

Traffics table

I want to display ecourse data with the amount of traffic per day using eloquent laravel. What's the solution?

Thank you

Please provide create table structures, sample data and expected result. stackoverflow.com/help/minimal-reproducible-example — Ersoy

Digvijay Digvijay · Accepted Answer · 2020-06-17T03:50:18

$ecourses = Ecourse::with(['traffics' => function($q){
    $q->groupBy('date')
      ->selectRaw('sum(amount) as sum, date');
}])->get();

Keep me posted in the comments below. Cheers!