INSERT INTO `table1` (`product_id`,`customer_group_id`,`priority`,`price`,`date_start`,`date_end`)
           VALUES
           ((SELECT `product_id` FROM `table2`
           WHERE
           product_code_id = '1223232ssdsad34'),'1','0','34332','2018-04-22','2018-04-26');

INSERT INTO table1 (product_id,customer_group_id,priority,price,date_start,date_end)
(SELECT product_id ,'1','0',price * 0.9,'2018-04-22','2018-04-26'
FROM table2
WHERE product_code_id = '1223232ssdsad34');