Mysql 中将select查询的值赋给insert语句-insert into select

场景：添加菜单的时候，有数据来源于前面的数据键值，例如父id

例子：

CREATE TABLE `menu`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父节点',
  `type` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源类型',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '资源名称',
  `url` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源路径',
  `parent_key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父菜单key',
  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 164 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;

插入新的一条数据：

INSERT INTO `sys_resource`(`parent_id`, `type`, `name`, `url`, `parent_key`) select id , 'menu', 'COMMON_PROBLEM', 'system/commonProblem/businessType', '' from sys_resource where parent_key = 'system';