/PHP/Avg rating get in join in laravel 8

Avg rating get in join in laravel 8

$users = User::where('type', 'instructor')->get();
  foreach ($users as $user) {
      $user['ratings'] = $user->ratings()->avg('rate');
  }
  return $users;


$data = User::with('ratings')
->join('Rating table','user.id','=','Rating table.user_id')
->select('user.*',DB::raw('avg(rating_for_user)'))
->get();

Similar codes

0 vote122 views1 answer
Php force array keys trim
PHP
1 vote150 views1 answer
Forenkey set inlaravel 8
PHP Laravel
6 votes139 views3 answers
Laravel 8 with jetstream
PHP Laravel
0 vote119 views1 answer
Laravel Facades\DB update
PHP
-1 vote139 views3 answers
Php tutorial for beginners
PHP
0 vote128 views1 answer
Remove all items of an array except the last 5 in php
PHP
4 votes158 views3 answers
Laravel on delete set null
PHP Laravel
0 vote124 views1 answer
Laravel self
PHP
0 vote256 views1 answer
Main features of php
PHP
0 vote159 views2 answers
Laravel create event listener
PHP