pass selected variable value to inside select query MySQL
SELECT product.*
FROM product
JOIN ( SELECT product_id id, MIN(price) price
       FROM product_stock
       GROUP BY 1 ) min_prices USING (id)
ORDER BY min_prices.price

If some products are absent in product_stock they won't be listed. If you need in them then use LEFT JOIN.