The following code will copy data from on table to another table. All you have to change the table names and fields name. Also it depends upon your requirement whether to use Where condition or not. So the below code is simple enough to make your task easy.
INSERT INTO tbl_category2 (cat_name,parent_id,status)
FROM tbl_category where parent_id=’0′