Laravel eloquent get one array of two dimensional arrays

Question

Here my code :

$classroom_ids = $user->classrooms->pluck('id');
            $classrooms = Classroom::with('students')
                ->whereIn('id', $classroom_ids)
                ->get();

I try to get all cumulated students on twos classrooms records.

I tried to use ->pluck('students') without success.

Here the classrooms datas :

0 => [
  'id' : 1,
  'students': Array of students
],
1 => [
  'id' : 2,
  'students': Array of students
],

How to get all students in one array ? Thanks

I think your query base model should be of Student instead of Classroom like Student::whereIn('class_id', $user->classroom->pluck('id'))->get() — Zohaib
– Zohaib, Commented Feb 25, 2021 at 17:20

Jed Lynch · Accepted Answer · 2021-02-25 17:17:14Z

4

Use map with flatten.

$classrooms = Classroom::with('students')
            ->whereIn('id', $classroom_ids)
            ->get()
            ->map(function($classroom){
                return $classroom->students;
            })
            ->flatten()
            ->toArray();

If students to classroom is a many to many you can use keyBy there are no duplicates.

$classrooms = Classroom::with('students')
            ->whereIn('id', $classroom_ids)
            ->get()
            ->map(function($classroom){
                return $classroom->students;
            })
            ->flatten()
            ->keyBy('id')
            ->toArray();

answered Feb 25, 2021 at 17:17

Jed Lynch

2,17720 silver badges17 bronze badges

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

1 Comment

Brian Lee Over a year ago

flatMap if you please :)

Tony S · Accepted Answer · 2021-02-25 17:25:25Z

0

Here the solution (inspired by Jed Lynch answer) :

$classroom_ids = $user->classrooms->pluck('id');
            $users = Classroom::with('students')
                ->whereIn('id', $classroom_ids)
                ->get()
                ->pluck('students')
                ->flatten();

Thank's for your help !

answered Feb 25, 2021 at 17:25

Tony S

5719 silver badges31 bronze badges

Collectives™ on Stack Overflow

Laravel eloquent get one array of two dimensional arrays

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related