$copy=$db->prepare("INSERT INTO tableName(column1, column2, column3,column4,column5) SELECT column1, column2, column3, column4, '$facultyid' FROM tableName WHERE id='235'"); $copy->execute();