using a foreign key or not?

I have a table with 5 fields (id, user_id','instruction', 'description', 'fk_eleve')

I want to retrieve the email user , I have tested this:

public function index(Request $request)

{   
    $user = $request->user();

    $feedbacks = Feedback::query()
    ->when($user->hasRole('admin') !== true, function (Builder $query) use ($user) {
        $query->where('email', $user->email);
    })
    ->when($request->has('search'), function (Builder $query) use ($request) {
     $query->join('eleves', 'feedbacks.fk_eleve', '=', 'eleves.id')->orderBy('eleves.nom', 'asc')->where('eleves.nom','like','%'.$request->input('search').'%');
     })
    ->paginate(5);

    return view('admin.feedbacks.index', compact('feedbacks'))
        ->with('display_search', $user->hasRole('admin'));
}

I have like error message:

SQLSTATE [42S22]: Column not found: 1054 Field Field 'email' unknown in where (SQL: select count (*) as aggregate fromreturnswhere email= test@gmail.com)

I have to create an email field? I can not get the email field of my fk_eleve?

Thank you

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2P6d0ag
via IFTTT