/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

3 votes124 views2 answers
Click confirm before submit form php
PHP
0 vote130 views1 answer
N months from today php
PHP
3 votes100 views1 answer
Laravel convert datetime to date
PHP
15 votes167 views6 answers
Laravel migration delete column
PHP Laravel
0 vote127 views1 answer
Laravel old value not working in textarea
PHP
7 votes131 views4 answers
Install or enable PHP's gd extension
PHP
4 votes133 views3 answers
Array search multidimensional php
PHP
0 vote166 views1 answer
Calculate average in eager loading laravel
PHP Laravel
6 votes155 views4 answers
Enset laravel session
PHP
0 vote134 views1 answer
Iterator
PHP