How to get a list of products, given their availability in the desired ones?

Question

Laravel

Good afternoon.
The situation is this: there are three tables

users - id, ...;
products - id, ...;
user_wishlist_products - id, user_id, product_id, ...;

Is it possible to use a join or something similar to display products, taking into account the presence in the wishlist, as elegantly and correctly as possible? Ideally, I would like this information to be displayed in a separate boolean field in_wishlist.

Answer 1

Well, if completely with the help of eloquent, then there is "withCount" , incl. with selection, which can then be converted to boolean