Laravel Eloquent ORM - 嵌套语句(Laravel Eloquent ORM - Nested with statements)

 所以我正在为我正在创建的Web应用程序创建一个API，并且我正在尝试将其保留在Eloquent ORM中。 我有一个亲子关系： 
 
 用户 - >站点日志 - >站点 
 
 网站类代码： 
 
class Site extends Model {
    public function log() {
        return $this->hasMany('App\SiteLog', 'site_id', 'id');
    }
}
 
 SiteLog类代码： 
 
class SiteLog extends Model
{       
    public function site()
    {
        return $this->belongsTo('App\Site', 'site_id', 'id');
    }

    public function user()
    {
        return $this->belongsTo('App\User', 'user_id', 'id');
    }
}
 
 当我使用以下方法实例化SiteLog类时： 
 
$sites = Site::with('log')->get();
 
 当我使用jQuery发出GET请求时，我得到了所有站点，并且在其中我有一个对象数组，其中包含站点各个日志的所有数据。 这正是我想要的。 但是，我想更进一步，让用户与日志相关联。 
 
 有点像这将如何工作： 
 
SiteLog::with('user')->get();
 
 但是在一个声明中，好像它是一个大的连接查询。 但是，我不确定Eloquent ORM是否涵盖了类似的测试用例。 
 
 有没有人做过这样的事情？ 我可以通过一些非常糟糕的实践或只是编写原始SQL查询来完成这项工作，但我只是想知道是否有更有说服力的方法来执行此操作。 

So I'm creating an API for a web application I'm creating and I'm trying to keep it within the Eloquent ORM. There is a parent-child relationship that I have going on:
 
User -> Site Logs -> Sites 
 
Site class code: 
 
class Site extends Model {
    public function log() {
        return $this->hasMany('App\SiteLog', 'site_id', 'id');
    }
}
 
SiteLog class code:
 
class SiteLog extends Model
{       
    public function site()
    {
        return $this->belongsTo('App\Site', 'site_id', 'id');
    }

    public function user()
    {
        return $this->belongsTo('App\User', 'user_id', 'id');
    }
}
 
When I instantiate the SiteLog class using: 
 
$sites = Site::with('log')->get();
 
When I make the GET request with jQuery, I get all of the sites and inside of them I have an array of objects with all of the data for the sites respective logs. Which is exactly what I wanted. However, I wanted to take it a step further and get the user that the log is associated with.
 
Sort of like how this would work: 
 
SiteLog::with('user')->get();
 
But all in one statement as if it was one big join query. However, I'm not sure if the Eloquent ORM covers a test case like that. 
 
Has anybody ever accomplished something like this? I can get this done with some pretty hacky practices or just writing a raw SQL query, but I am just wondering if there was a more eloquent way of doing this. 

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