Hello,
You can use LEFT JOIN to retrieve the necessary item wise data.
SELECT b.bill_id, b.order_id, b.food_id, f.food_name, f.food_price, o.food_quantity FROM bill_table b LFFT JOIN food_table f ON f.food_id = b.food_id LEFT JOIN order_table o ON o.order_id = b.order_id
Regards,