laravel - MySQL - Combine this into one Query in Eloquent? -
given following schemas:
user - id - username friends - user_id - friend_id places - id - name place_user - user_id - place_id users have manytomany relationship via friends pivot.
places have manytomany relationships users via place_user
how places associated user , user's friends?
assuming we're working user 1, in raw sql, can places associated user's friends:
select places.place places inner join place_user on place_user.place_id = places.id inner join friends on friends.friend_id = place_user.user_id inner join users on users.id = place_user.user_id friends.user_id = 1 and can places associated user:
select places.place places left join place_user on place_user.place_id = places.id left join users on users.id = place_user.user_id users.id = 1 but how can combine 1 query, , moreover, using eloquent?
edit: union of these 2 queries, wondering if there's more succinct, , perhaps less verbose in eloquent
Comments
Post a Comment