Yes. Foreign keys can refer to another column in the same table. The top-level folder might need to be its own parent - I don't know if it'll let you have a NULL there. As long as the interface ...

Duplicate and Ignore on MySQL Inserts. MySQL table primary keys and unique indexes prevent multiple rows with the same index from being added to the table. If you try to insert a duplicate row ...