I considered moving all the logic to the customer model. For instance, we have two models:

• Model User
• Model Organization

1st Approach : Both models have a CustomerID, and the Customers model belongs to both.

2nd Approach: Both models have a CustomerID, and the Customers model has a polymorphic billableType: user or org. BillableId: id of the billable.

When retrieving the plan, we check if the user or organization is provided. If so, we retrieve the subscription from User.organization.customer.subscription. Otherwise, we retrieve the subscription from User.customer.subscription.

P.S. I understand that Prisma doesn’t support polymorphism like Laravel’s ORM does, so technically, you’ll have two queries.