and example of this is 1 product category can have multiple products.

This requires a feature like join which we are working on, but is not available at the moment.