CakePHP Tree Behavior - products has more than one category

Question

How rebuild table 'products' with actually field 'category_id', when I use Tree Behavior, to for one products belongs to more than one category?

Answer 1

You would have to use a habtm join with a categories_products table instead of a single category_id in the product table

products               categories_products            categories
-------------          -------------------------      ---------------------
id | name| ..          id|category_id|product_id      id|name|parent_id|...