take() for each unique id

@Sinnbeck You are correct, I have a typo in my post which is confusing - This is a second table with ids as foreign keys so it should've been:

Table2::whereIn('table_1_id', $ids_arr)->get();

@Ligonsker Ok then try

Table2::select('table_1_id')->whereIn('table_1_id', $ids_arr)->groupBy('table_1_id')->limit(5)->get();

Or

Table2::distinct('table_1_id')->whereIn('table_1_id', $ids_arr)->limit(5)->get();

@Sinnbeck The problem with this, is that it always gives 5 results, but not 5 from each

@Ligonsker Ah ok. You need to write some sort of windows function for that. Cannot write it off the top of my head, but I can help you google for it.

Edit: something like this: https://ubiq.co/database-blog/mysql-select-top-n-rows-per-group/

@Sinnbeck thank you! will take a look into it