doufenpaiyu63706 2016-10-27 12:45
浏览 51
已采纳

Laravel Eloquent使用相同的外键获得多条记录

I have 3 tables:

User
------------------
ID 
Name


Room
------------------
ID
Subject



Participate
-------------------
ID
room_id
user_id

and it's my sample data:

user                        room                    participate
-----------------           ----------------        ---------------------
ID     Name                 ID     subject          ID  room_id  user_id  
-----------------           ----------------        --------------------- 
1      john                 1      room1            1     1       1
2      sara                 2      room2            2     1       2
3      david                3      room3            3     3       3
                                                    4     3       2
                                                    5     3       1
                                                    6     2       1

Now I access to user_id but I want to find room_id that have shared with user_IDs in participate table. For example I have user_id: 1 & user_id: 2 and want to get shared room_id 1. Already I filter participate model by user_id but I don't know to find room_id.

Thanks

  • 写回答

1条回答 默认 最新

  • doushi4795 2016-10-27 12:58
    关注

    You can try to create such a query:

    $usersIDs = [$userId, $secondUserId]; //here define user ids how many  you want
    
    DB::table('room')->select('room.*')
        ->join('participate', 'participate.room_id', '=', 'room.id')
        ->join('user', 'user.id', '=', 'participate.user_id')
        ->whereIn('user.id', $usersIDs)
        ->havingRaw('count(user.id) = ?', [count($usersIDs)])
        ->groupBy('room.id')
        ->first();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?