How to get All data from a model except one?

Question

I want to retrieve all users data except one.for that i used the following query

$users=User::whereNotIn('name',['admin'])->pluck('id','name');

When i dd() the output I see all the users data except the one But when I send the query results in foreach() loop in view page I see

Trying to get property of non-object

Error in view page.What's the Error here? Can anyone suggest me please?

Here is the foreach loop i used in view page

@foreach($users as $user)
          <option value="{{$user->id}}">{{$user->name}}</option>                        
@endforeach

Answer 1

$users = User::where('id', '!=', Auth::id())->get();

this one except current login user..you can set admin id...in such field.. or you can use this also..

$users = User::all()->except(Auth::id());

both are work!!

Answer 2

pluck() creates an array with [id => name] structure, so change the code in assign_rol‌​e.blade.php to:

@foreach ($users as $id => $name)
    <option value="{{ $id }}">{{ $name }}</option>                        
@endforeach

And pluck() parameters to:

->pluck('name', 'id');