UPDATE goods AS tbl_1
    INNER JOIN(
        SELECT goods_id, (round((count_from+count_to)/2, 2)) AS cnt
        FROM ingredients where menu_id = 2 and count_to <= (select `count` from goods where id = goods_id)
       
    ) AS tbl_2 
SET tbl_1.`count` = (tbl_1.`count`- tbl_2.cnt)
where tbl_1.id = tbl_2.goods_id

  SELECT goods_id, (round((count_from+count_to)/2, 2)) AS cnt
        FROM ingredients where menu_id = 2 and count_to <= (select `count` from goods where id = goods_id)

select id, `count` from goods where id = 2 

UPDATE goods AS tbl_1
    INNER JOIN(
        SELECT a1.goods_id, (round((a1.count_from+a1.count_to)/2, 2)) AS cnt
        FROM ingredients a1
       
    ) AS tbl_2 on tbl_2.menu_id = 2 and tbl_2.count_to <= (select a2.`count` from goods a2 where a2.id = tbl_2.goods_id)
SET tbl_1.`count` = (tbl_1.`count`- tbl_2.cnt)
where tbl_1.id = tbl_2.goods_id;