laravel 闭包子查询
User::whereIn('id', function($query){ $query->select('user_id') ->from('admin_user') ->whereIn('type', ['1', '2']); })->get();
输出sql
SELECT * FROM `user` where `id` IN ( SELECT `user_id` FROM `admin_user` WHERE `type` IN (1, 2) );
User::whereIn('id', function($query){ $query->select('user_id') ->from('admin_user') ->whereIn('type', ['1', '2']); })->get();
输出sql
SELECT * FROM `user` where `id` IN ( SELECT `user_id` FROM `admin_user` WHERE `type` IN (1, 2) );
文章数
437
浏览数
100061
今日发布
0