Is there a way to (re)map Laravel Collections with an index from its content?

Question

I have some Newsletters:

$newsletters = $channel->Newsletter()->whereIn('id', $wantNewsletters)->get();

Which result in this collection:

I tried to use pluck, but it just allows one column:

$newsletters = $channel->Newsletter()->whereIn('id', $wantNewsletters)->pluck('media', 'id');

What I try to achieve is this (pardon my sad paintshop skillz :D)

In a way, that's like ->pluck('*', 'id'). For now I had to foreach every collection and this does not seem right to me.

Thanks for your help!

Answer 1

You can use keyBy method:

$newsletters = $channel->Newsletter()->whereIn('id', $wantNewsletters)->get()->keyBy('id');