php - Laravel modal query

one text

Solution:

When you are doing this $query->select('serial_number'); you are only selecting serial_number and not the column that connects both the modals i.e. product_id inside barcodes table.

Do this. $query->select('product_id', 'serial_number');. However this will return 2 columns. If you want just one then you will have to use collection transform.

$products = $products->map(function ($product) {
    $product->allBarcodes->transform(function ($q) {
        return $q->serial_number;
    });
    return $product;
});

Keep me posted in the comments below.