我有一个类别列表（excel csv文件），带有相关的标准ID。这些类别具有子类别，这些子类别又具有第二组子类别。 这将继续下降5个级别。

我想将此导入到mysql表中，以便可以使用。

CSV文件如下所示。此外，每个类别和子类别都以/

Criterion ID        Category    SubCategory SecondSubCategory   ThirdSubCategory    FourthSubCategory   FifthSubCategory
10021       /Apparel                    
10178       /Apparel    /Apparel accessories                
10937       /Apparel    /Apparel accessories    /Bags & Packs           
12262       /Apparel    /Apparel accessories    /Bags & Packs   /Backpacks & Utility Bags       
12264       /Apparel    /Apparel accessories    /Bags & Packs   /Briefcases     
12263       /Apparel    /Apparel accessories    /Bags & Packs   /Handbags & Purses      
12265       /Apparel    /Apparel accessories    /Bags & Packs   /Laptop & Computer Bags     
10935       /Apparel    /Apparel accessories    /Belts & Suspenders         
10938       /Apparel    /Apparel accessories    /Billfolds & Wallets            
10936       /Apparel    /Apparel accessories    /Eyewear            
12260       /Apparel    Apparel accessories Eyewear Reading Glasses     
12261       Apparel Apparel accessories Eyewear Sunglasses      
10939       Apparel Apparel accessories Gloves & Mittens            
10942       Apparel Apparel accessories Hair accessories            
10941       Apparel Apparel accessories Headwear            
12266       Apparel Apparel accessories Headwear    Hats        
12267       Apparel Apparel accessories Headwear    Headscarves & Bandanas      
13701       Apparel Apparel accessories Key Chains & Key Rings          
13409       Apparel Apparel accessories Parasols & Personal Sun Umbrellas           
10943       Apparel Apparel accessories Scarves & Shawls            
10940       Apparel Apparel accessories Ties            
10176       Apparel Clothing                
13780       Apparel Clothing    Children's Clothing         
11019       Apparel Clothing    Children's Clothing Baby & Toddler Clothing     
12292       Apparel Clothing    Children's Clothing Baby & Toddler Clothing Baby & Toddler Shoes    
12293       Apparel Clothing    Children's Clothing Baby & Toddler Clothing Christening Gowns & Suits   
12288       Apparel Clothing    Children's Clothing Baby & Toddler Clothing Newborn Clothing    
10924       Apparel Clothing    Costumes & Costume Rental           
10919       Apparel Clothing    Culturally-Specific Clothing            
10906       Apparel Clothing    Custom Clothing         
10916       Apparel Clothing    Dancewear           
10920       Apparel Clothing    Formal Wear         

我不知道如何导入此文件，除了手动将其绘制到一个表中（因为该文件超过3000行长的csv文件），这将永远需要。

我希望有一种方法可以通过PHP或某种形式的Mysql Import完成。

我正在描绘一个导入，就像这样： 标准ID |分类|家长编号