使用Laravel Eloquent在单个查询中获取基于不同列的行

Question

Let's say I have a table that looks like this:

name | link
-----------
 A   | asdf 
 A   | zxcv
 B   | qwer
 B   | rtyu
 C   | fghj

I am currently getting the results using 2 queries like the following using the $link variable:

// first query to get the row so I have the name
$m = Model::where('link', '=', $link)->get();    

// using the name, I get the rows I need
$results = Model::where('name', '=', $m->name)->get();

How can I do this in a single query?

Answer 1

You can use Builder::whereIn and subqueries to achieve what you want:

Model::whereIn("name", function ($query) use ($link) {
    $query->select("name")
        ->from((new Model)->getTable())
        ->where("link", $link);
})->get();