mysql - 在laravel中编写连接同一个表的代码

Question

我有 2 张 table

Table 1: farm has columns id, name, id_tech, id_manager
Table 2: User has columns: id, name

我在 mysql 中运行以下语句:

 SELECT eco_farm.id, eco_farm.name as farmname, A.name as manager, 
       B.name as tech 
 FROM eco_farm 
 LEFT JOIN eco_user A ON A.id = eco_farm.id_manager 
 LEFT JOIN eco_user B ON B.id = eco_farm.id_tech

结果是

但是我不知道如何在 laravel 中编写代码如何在 laravel 中检索数据。愿你帮助我。谢谢

Answer 1

这是使用查询生成器。

$result = \DB::table('eco_farm')
    ->leftJoin('eco_user as A', 'A.id', '=', 'eco_farm.id_manager')
    ->leftJoin('eco_user as B', 'B.id', '=', 'eco_farm.id_tech')
    ->selectRaw('eco_farm.id, eco_farm.name as farmname, A.name as manager, B.name as tech')
    ->get();

查看文档以获取更多信息和示例 https://laravel.com/docs/5.4/queries