Best way to create category & product tables ?

@mkojoa What have you tried so far?

It looks like a normal parent > child relation what you describe (or tree node).

A category can have one parent category or multiple subcategories. And depending on your requirement a product can be attached to one single category or to multiple categories.

@martinbean thanks for replying. I have category table with fields[name, ...] and subcategory with fields[category_id, name, product, ..] and product which contains the [ name, category_id ] table.

@CLICK - tree node, please

@MKOJOA - To be able to create a parent > child > grandchild > etc. relationship you do not need a subcategory table. You could add a nullable parent_id to your category table and setup the relationships.

tree node, please

We are not going to build that for you. This isn't a job site. Google the terms laravel tree or laravel nestedset and you will find some examples

@click please you can provide some links because am new to this. please

@CLICK - Thanks