使用PHP和SQL将数据从HTML表单和其他表插入到新表中

sealife_customer:

sealife_trip

My query for inserting data from the HTML form (trip_id, email, pay_num, pay_expiry, pay_cvv) and getting data from the sealife_customer and sealife_trip table:

$Query = "insert into sealife_booking values ('$trip_id', '$email', depart_date, first_name, last_name, address, phone, '$pay_num', '$pay_expiry', '$pay_cvv'')
        SELECT t1.email, t2.depart_date, t1.first_name, t1.last_name, t1.address, t1.phone
        FROM sealife_customer t1
        LEFT JOIN sealife_trip t2
        WHERE t1.email = '$email'";

So I'm unsure how I combine both the HTML form variables, and the already established data in the customer and trip tables to insert into the new table sealife_booking. The email is the key that links the customer to the booking.

How can I combine both tables and HTML form data to insert in the new table?

Thank you.