INSERT through SELECT data from another table with additional manual data PHP SQL

I am trying to insert the data from the other table, It is not working I read all the threads on StackOverflow and w3school but based on it my SQL not working.
I am trying to insert the all data one by one which available in table pincode WHERE state = US
I think my code is right but it not inserting the data. I am selecting some around three cols from pincode table and others for I manually assign the parameter in execute array in PHP