INSERT INTO user_auth(userid, auth_plane_id)
select user.user_id AS userid, plane.id AS auth_plane_id
FROM user, plane
WHERE user.name = ‘陈‘ and plane.name=‘737‘;
或者用join的方法.
insert into select 多个表
原文：https://www.cnblogs.com/mafeng/p/10325848.html
