Level 75
$ids = PAddressDetail::find($addressId)->colistAgent()->pluck('id');
$allUsers = User::orderBy('users.created_at', 'asc')
->join('role_users', 'users.id', '=', 'role_users.user_id')
->join('roles', 'role_users.role_id', '=', 'roles.id')
->where('role_users.role_id', '=', '3')
->where('users.id' , '!=', $userData['user_id'])
->whereNotIn('users.id', $ids)
->get()
->toArray();
1 like
