您可以使用 select 创建

You can create with select

create table3 (p_id int(1), u_id int(11), review varchar(64)); 
insert table3 select Products.p_id, Users.u_id, 'value_for_review'
from Products, Users