Laravel 链表查询多条件

$zubie = BomAllocations::from('bom_allocations as ba')->leftJoin('bom_headers as bh', function ($join) {
                    $join->on([
                        ['ba.bom_group', '=', 'bh.group'],
                        ['ba.group_counter', '=', 'bh.counter'],
                    ]);
                })->where('ba.mat_code', $value['mat_code'])->where('bh.version', $version)->pluck('bh.p_group')->first();
                if ($zubie) {
                    $temp_result = $filtered->where('bom_group', '=', $zubie[0])->where('bin_code', '=', $stockBin)->all();
                }