How to get array of nested relations into single Array in Laravel

Question

Item Model:

public function item_makes(){
     return $this->hasMany(ItemMake::class,'item_id','id');
}

In ItemMake Model :

public function make(){
    return $this->belongsTo(Make::class,'make_id','id');
}

I need to get array of all make based on item_id. How to achieve this? Thanks in Advance.

Neha · Accepted Answer · 2019-03-28 05:49:50Z

2

This worked for me.

$item = Item::findOrFail(1)
         ->item_makes()
         ->with('make')
         ->get()
         ->pluck('make')
         ->flatten()
         ->toArray();

answered Mar 28, 2019 at 5:49

Neha

2,3115 gold badges27 silver badges56 bronze badges

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

Comments

piscator · Accepted Answer · 2019-01-08 11:22:03Z

1

Try something like this:

Item::findOrFail(1)
    ->with('item_makes.make')
    ->get()
    ->pluck('make')
    ->flatten()
    ->toArray()

answered Jan 8, 2019 at 11:22

piscator

8,8495 gold badges26 silver badges35 bronze badges

3 Comments

Neha Over a year ago

Thank you so much Sir :)

Hilmi Erdem KEREN Over a year ago

You can also use whereHas method from Make model. This way, you wouldn't need to flatten or pluck.

piscator Over a year ago

I agree, but then you would also need a subquery to only get makes that belong to item_makes of an item with the given id.

sid heart · Accepted Answer · 2019-01-08 11:48:03Z

1

Try wherehas method something like this

$makes = Make::whereHas('item_makes', function ($query) use($item_id) {
   $query->where('item_id',  $item_id);
})->get();

answered Jan 8, 2019 at 11:48

sid heart

1,1491 gold badge13 silver badges44 bronze badges

Collectives™ on Stack Overflow

How to get array of nested relations into single Array in Laravel

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related