php - select from multiple table and write on one table w3schools -

i want select multiple table , write on 1 table:

insert interest_area (category_id, user_id)         select category_id category         category_name = 'html'          union         select user_id users         first_name = 'memar'; 

but couldn't write.

change query like

insert interest_area (category_id, user_id)     select category_id,user_id category c,users u     c.category_name = 'html' , u.first_name = 'memar';