How can I fetch the nested relation through a single statement into an array

Question

I have four models each having hasMany relations to each other.

A hasMany B B hasMany C C hasMany D

My main model is A and I want to fetch D through A. I am querying like this to get D.

A::with('B.C.D')->get();

I am fetching D like this:

$answer = [];
foreach(A as a) {
    foreach(a->B as b){
        foreach(b->C as c) {
            foreach(c->D as d) {
                $answer[] = d;
            }
        } 
    }
}

But I want to reduce these arrays into a single statement, is it possible to do it?

Vivek Pawar · Accepted Answer · 2021-10-06 06:30:13Z

1

You can use pluck() and collapse().

A::with('B.C.D')->get()->pluck('B.*.C.*.D.*')->collapse();

It directly gives you D's model data.

Let me know its solve your issue or not.

edited Oct 6, 2021 at 6:30

answered Oct 6, 2021 at 6:22

Vivek Pawar

7146 silver badges12 bronze badges

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

1 Comment

Vivek Pawar Over a year ago

The pleasure is all mine. Happy Coding :)

Bishal Jung Chettri · Accepted Answer · 2021-10-06 06:58:16Z

0

You can use laravel Helpers data_get() to get nested data easily. Laravel has a lots of helper functions . Going through these function helps a lot.

In your case:

data_get($variable, 'a.b.c')

answered Oct 6, 2021 at 6:58

Bishal Jung Chettri

3942 silver badges14 bronze badges

Collectives™ on Stack Overflow

How can I fetch the nested relation through a single statement into an array

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related