How to import categories from string in php?

Question

PHP

There are lines:

Товар;Тип1;Тип2
Товар;Тип1;Тип3
Товар;Тип1;Тип3;Тип4
Услуга;Тип1;Тип2

How to write a PHP script to convert to a tree structure in a MySQL database
As a result, I want to get this:

Where pid is the id of the highest category

Answer 1

a) replace the specified structure with regular SQL queries (it is very convenient in Notepad++)
b) use a service like www.convertcsv.com/csv-to-sql.htm
c) there is an import from CSV in phpMyAdmin