how to insert subcategory into parent category(All) in mysql?

I need to insert subcategory values into parent category in mysql without using loop.do u guys have any efficient queries.(i am inserti开发者_开发技巧ng subcatgories using csv file upload)

Use the Nested Set principle. Here is a really good article: Managing Hierarchical Data in MySQL, which in principle also applies to other relational databases.