Laravel数据库将列数据传递给其他表

Question

Currently I have 3 table and there has two table already joined together to allow me to get some data. Now I just need to take one of the columns in the third table then pass to the joined table.

    $qryBlder = function ($qry) {
        $qry->join('branch_product', 'products.id', '=', 'branch_product.product_id')
            ->select('products.id', 'products.sku', 'products.name', 'branch_product.available_stock', 'branch_product.avg_cost')
            ->where(function ($qry) {
                if (Branch::getId() > 0) {
                    $qry->where('branch_product.branch_id', '=', Branch::getId());
                }
            })
            ->orderBy('products.sku');
        if (Input::get('show_all', 0) == 0) {
            $qry->where('branch_product.available_stock', '>', 0);
        }
        return $qry;
    };

    $queryInv = Inventory_log::selectRaw('product_id')
                ->whereBetween('inventory_logs.log_date',array($init['startdate'], $init['enddate']))
                ->addSelect(DB::raw('SUM(qty) AS total'))
                ->where('type','=' ,'as')
                ->groupBy('product_id')
                ->get();

&qryBlder and $queryInv is working fine now. I'm trying to pass Inventory_log qty column to products table which allow me to get qty total as products.qty. However, the table column always not found in products table.