INSERT INTO `table1` (`name`) VALUES ('Яблоки');
INSERT INTO `table2` (`table1_id`, `color`)
    SELECT t1.ID, 'зелёные'
    FROM `table1` t1
    WHERE t1.`name` = 'Яблоки';