How to associate product to all categories in database

[Spouter]

I have more than 10 000 producst in my store, but each product is associated only in last subcategory. Is there some simple query, how to associate each product to all parent categories depending on subcategory? I'm using PS 1.6.1.24.

For example i have product ONE and category path: MainCategory - SubCategory1 - SubCategory2 - SubCategory3.

Product ONE is associated only in last category SubCategory3. How to associate product to SubCategory2, SubCategory1 and MainCategory?

Thanks for your suggestions.