How to join results from with operator in Laravel?

Question

I use query builder for execution inquiries to db like as:

$result = Order::with("product", "images");

As result I get response with two nested objects inside:

{["product" : [{}], "images" : [{}]]}

How can I join these two objects to one, that to get the following response:

{"title" : "Product name", "price" : 3, "images" :{}, "order" : {} }

what is the relation between Order and product, images? Also, are you sure there is a relation between order and images and not product and images? — Vishal Sharma
– Vishal Sharma, Commented Jan 2, 2017 at 9:04
Relations between Order and Product is: Order.product_id = Product.id and Product.image = images.id — Hamama
– Hamama, Commented Jan 2, 2017 at 9:10

Alexey Mezenin · Accepted Answer · 2017-01-02 09:15:57Z

2

You should use nested eager loading here:

Order::with('products.images')->first();

If you want to get an array or JSON instead of collection, use toArray() or toJson() methods on collection.

answered Jan 2, 2017 at 9:12

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

3 Comments

You have to remove the first products, because products.images will load products.

In this case you will get object products and inside object images. But I need join this in one object product

@Hamama did you try to use toArray() or toJson() as I suggested?