Laravel QueryBuilder return array of values

Question

In my application, there are two models:

person
subject

there's a many-to-many relationship between those two.

In order to fetch all people (person) with their respective subjects, I do;

   $people = Person::with(['subjects' => function($query) {
     $query->select('id');
   }]);

Results in:

{
            ...

            "subjects": [
                {
                    "id": 16
                },
                {
                    "id": 21
                },
                {
                    "id": 32
                }
            ],
},

I am wondering is there an elegant way to get an array of subject ids instead:

{
            ...

            "subjects": [
                10,
                14,
                21,
                38
            ],
},

Alexey Mezenin · Accepted Answer · 2017-07-23 10:36:23Z

2

You can use map() collection method. I've just tested this solution with many-to-many relationship and it works fine:

$collection->map(function ($i) {
    $i->subjectArray = $i->subjects->pluck('id')->toArray();
    unset($i->subjects);
    return $i;
});

answered Jul 23, 2017 at 10:36

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

2 Comments

Yonatan Naxon Over a year ago

Thought about looping through the collection, wondered if there's a more elegant solution

Alexey Mezenin Over a year ago

@YonatanNaxon you could use your own method instead of with() to load related data (or your own collection method), but this is a bad idea for many reasons. I wouldn't recommend you modify collection at all, but if you need to, using map() is the best solution here.

Collectives™ on Stack Overflow

Laravel QueryBuilder return array of values

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related