在雄辩的laravel中基于来自子模型的参数查询第一模型(Query first model based on parameters from child model in eloquent laravel)

 我有2个用户表与相应的User和BUser雄辩模型。 我正在尝试查询User并仅根据BUser上的参数返回结果。 
 
 我目前正在这样做： 
 
public function scopeMarketplace($query) {
    return $query->with(['buser' => function($q) {
        $q->where('marketplace', '=', 1);
    }]);
}
 
 如果marketplace = 1那么返回所有User但仅包括BUser但我不想返回任何User除非满足相应的BUser参数。 SQL最终成为： 
 
select * from `users` limit 50 offset
select * from `busers` where `busers`.`id` in ('62', '63', '99', '100', '101', '102', '104', '105', '106', '107', '108', '109', '110', '111', '113', '114', '115', '116', '117', '118', '126', '128', '130', '131', '132', '142', '144', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '159', '165', '166', '167', '168', '169', '170', '171', '172') and `marketplace` = '1'
 
 这将获取所有User对象，然后查询BUser - 因此返回错误的数据。 
 
 User对BUser的关系是： 
 
/**
 * @return \Illuminate\Database\Eloquent\Relations\HasOne
 */
public function buser()
{
    return $this->hasOne('App\BUser', 'id', 'id');
}

I have 2 users tables with corresponding User and BUser eloquent models. I'm trying to query User and only return results based on parameters on BUser.
 
I'm currently doing this:
 
public function scopeMarketplace($query) {
    return $query->with(['buser' => function($q) {
        $q->where('marketplace', '=', 1);
    }]);
}
 
Which is returning all Users but only including BUser if marketplace = 1 but I don't want to return any Users unless the corresponding BUser parameters are met. The SQL ends up being:
 
select * from `users` limit 50 offset
select * from `busers` where `busers`.`id` in ('62', '63', '99', '100', '101', '102', '104', '105', '106', '107', '108', '109', '110', '111', '113', '114', '115', '116', '117', '118', '126', '128', '130', '131', '132', '142', '144', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '159', '165', '166', '167', '168', '169', '170', '171', '172') and `marketplace` = '1'
 
This gets all User objects and then query's BUser - so returns the wrong data.
 
The relationship in User for BUser is :
 
/**
 * @return \Illuminate\Database\Eloquent\Relations\HasOne
 */
public function buser()
{
    return $this->hasOne('App\BUser', 'id', 'id');
}

原文：https://stackoverflow.com/questions/32331730