PHP MySql将列从一个表插入另一个表

I want to insert my table data from copying another table with some new given data.

I use this query

$sql = "INSERT INTO table2(name, city, email,money) 
   hasib,SELECT table1.city, table1.email, 
   newsletter_subscribers.email 
   FROM table1 WHERE name='jesy',100";

But its not Work

You must give all columns inside the select statement columns, even constant values, e.g.

insert into table2(name, city, email, money)
select 'hasib', city, email, 100
from table1
where name = 'jesy'

If you want to take values from multiple tables, as your select statement suggests, you must look into joins.