/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 vote163 views1 answer
Use multiple pagination in same page laravel
PHP Laravel
0 vote138 views1 answer
How to develop package beside laravel project
PHP
3 votes197 views6 answers
Laravel jwt token
PHP Laravel
5 votes158 views6 answers
Hello world php
PHP
3 votes181 views1 answer
How to add newline in php
PHP
0 vote170 views1 answer
Laravel array search blade
PHP Laravel
0 vote269 views1 answer
Show sender name laravel
PHP Laravel
59 votes175 views6 answers
Laravel seeder
PHP
0 vote157 views2 answers
Concat in where clause laravel query builder
PHP Laravel
1 vote134 views1 answer
Laravel command parameter optional
PHP