How to use query sql for show parent table in laravel

Question

How to display room rates using mysql query?

I have 2 tables, namely the room table and the rental rate table, I want to display the rental rates for each room.

How to call it with mysql query ? i have tried using grouping, join. But it didn't work. Please help

You can use eloquent ORM or DB facade for getting data from database instead of using sql queries. — Vinod Patidar, Jul 28 '22 at 08:54

score 0 · Accepted Answer · answered Jul 28 '22 at 08:56

0

In your Room model add this relationship:

    public function rates()
    {
        return $this->hasMany(RentalRate::class);
    }

In Controller call:

$rooms = Room::with('rates')->get();

1 Answers1