Fluent:

DB::table('PRODUCTS')->whereIn('parent_id', $parent_ids)->get();

雄辩:

Product::whereIn('parent_id', $parent_ids)->get();