how to get order details based on multiple user of single item laravel

Question

$users = User::where('parent_id', $user_id)
                ->get()
                ->toArray();

$query = Order::where('item_ids' , $item_id);

for ($i = 0; $i < sizeof($users); $i++) {

    $query->where(function($q) use ($users, $i) {
        $q->where('user_id', $users[$i]);
    })
    ->orderBy('created_at', 'desc');

}

How can I get all users based on item_id?.

I tried above code which doesn't work. Please guide.

How to get order details based on multiple user of single item?

Answer 1

for loop slows down the processing you can use laravel query builder such as where

for more details https://laravel.com/docs/5.5/queries

$users = User::where('parent_id', $user_id)->pluck('user_id')->toArray();
    $query = Order::where('item_ids' , $item_id)->whereIn('user_id', $users)
    ->orderBy('created_at', 'desc')->get();

Hope this helps you.