how to select join subquery using laravel query builder

how to select join subquery using laravel query builder

sql select statement

SELECT  product_name.name
    , product_price.weight
FROM    product_price
LEFT JOIN product_name
    ON (SELECT product_price.product_code
        FROM product_price
        LEFT JOIN product_name
            ON  product_price.product_code = product_name.code
        WHERE product_price.barcode = '1234567890'
    )

How to convert sql select statement to Laravel query builder?

via Chebli Mohamed