How to change active record to fulfill double condition with joins?

Question

PostgreSQL

I have such a query in ActiveRecord on my project, which returns categories based on the presence of providers in subcategories:

Category.joins(subcategories: [:service_providers]).uniq

Can you tell me how to substitute a double condition so that only those categories are returned, in the subcategories of which there is at least one service_provider with the status published: true?
Thanks

Answer 1

Category.joins(
  subcategories: :service_providers
).where(service_providers: { published: true }).uniq

It is assumed that your table is called service_providers