您可以使用 insert 和 select 并在 select 语句中提供您的 shop_id

You can use insert with select and provide your shop_id in select statement

INSERT INTO menu_list_hed
    (`menu_name`, `shop_id`, `menu category`)
select `menu_name`, '13' AS `shop_id`, `menu category`
from menu_list_hed where shop_id = 12
;

演示