select all the items in your table that have parent ids into the temporary table.

drop your old table and then rename your temporary table to the dropped table name.

then add a constraint on your secondary table that points to the primary key of the main table, that way you won't add orphan records in the future. note this last bit only works if you are using innodb tables and not myisam tables.