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 ...

MySQL performance tip No. 2: Secondary keys are not your enemy Secondary keys are updated by a background process. As a result, the performance impact is not as serious as you would expect.