php - Where clause in eloquent relation in laravel

Question

I have two models Student and Fees which has relations

• Student has many Fees
• Fees belongsTo Student

In Student.php

public function fees()
{
    return $this->hasMany(Fees::class, 'std_id');
}

In Fees.php

public function student(){
    return $this->belongsTo(Student::class,'std_id');
}

Now I need to Find Fees for individual students. What should I do now?

In controller

$fees = Fees::with('student')->where('fees->student->id', '=', $request->id)->get();

it's not working...

question from:https://stackoverflow.com/questions/65713781/where-clause-in-eloquent-relation-in-laravel

Answer 1

Try this

$student_fees = Student::find($request->id)->fees;