Laravel select * where id =(select id )

Laravel select * where id =(select id )

提问by Ufc Champion Mohamed Abd-Elham

Using Laravel eloquent how do I make a query like this:

使用 Laravel eloquent 如何进行这样的查询：

 select * from branches where user_id =(select id from users where name ='sara' )

回答by Rwd

Assuming that you have a userrelationship in your Branchmodel you could use whereHas:

假设user您的Branch模型中有关系，您可以使用whereHas：

$branches = Branch::whereHas('user', function ($query) {

    $query->where('name', 'sara');

})->get();

Hope this helps!

希望这可以帮助！

回答by MartinLeitgeb

I would split it into two queries. First getting the id, then getting the list. Expecting your models to be called "User" and "Branches"

我会把它分成两个查询。首先获取id，然后获取列表。期望您的模型被称为“用户”和“分支”

$user = User::where('name', 'sara');
$id = $user->id;
$branches = Branch::where('id', $id);

This site may help you Link

这个网站可以帮助你链接

回答by Kuldeep Mishra

 $id = Users::select('id')->where('name','sara')->first();
 $barnches = branches::where('id',$id)->get();

Here Users and branches are models , first is using for 1 row and get for many rows

这里用户和分支是模型，首先使用 1 行并获取多行

回答by Zayn Ali

Try this.

尝试这个。

$name = 'sara';

$results = BranchModel::whereIn("user_id", function ($query) use ($name) {
    $query->select("id")
        ->from((new UserModel)->getTable())
        ->where("name", $name);
})->get();