How to get join results as an array of objects in Laravel?

Question

I have been working on a personal project where users can rate different shops. Among many, I have two tables schemas that I am working on.

Table: Shops

id
shop_name
user_id (shops belongs to a user)

Table : Ratings

id
shop_id (foreign_key)
rating
user_id

Now I want to fetch all the shops and its corresponding ratings using SQL join.

 $shop = Shop::leftJoin('ratings', 'ratings.shop_id', '=', 'shops.id')
    ->select('shops.*', 'ratings.rating')->get();
    return response($shop);

When I do this I get response but the it is repeated for each ratings on the same shop.

[
    {
        "id": 1,
        "name": "manjil",
        "rating": 4
    },
    {
        "id": 1,
        "name": "manjil",
        "rating": 5
    },
    {
        "id": 1,
        "name": "manjil",
        "rating": 2
    }]

What I really want is :

        [{
            "id": 1,
            "name": "manjil",
            "rating": [4,5,2]
        }]

Please Laravel geeks, help :)

try ->groupBy('rating'); before ->get();

xNoJustice
– xNoJustice

2020-07-28 15:01:55 +00:00
Commented Jul 28, 2020 at 15:01 — xNoJustice
– xNoJustice, Commented Jul 28, 2020 at 15:01

N69S · Accepted Answer · 2020-07-28 18:27:32Z

5

the easy solution would be to use the relation directly

$shops = Shop::with('ratings')->get();
//possible mapping here
return response($shops);

you can afterwards map the ratings to get only an array of the field rating

$shops = $shops->map(function ($shop) {
    $shop->ratings = $shop->ratings->pluck('rating')->all();
    return $shop;
});

edited Jul 28, 2020 at 18:27

answered Jul 28, 2020 at 15:05

N69S

17.3k4 gold badges25 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get join results as an array of objects in Laravel?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related