How to organize folder/subfolder storage in mysql?

Question

MySQL

There is a brand. The brand has a product that is in folders. Folder nesting level can be any. How to store it properly?

Answer 1

Google:

• Adjacency List
  
• materialized path
  
• Nested Sets
  
• Closure Table
  

Answer 2

alternatively, a table for folders with fields:
id - primary key
brand_id - foreign key referring to the brand
parent_id - secondary key - id of the parent folder
+ other fields relevant for the folder