{"id":1011,"date":"2025-06-12T04:49:34","date_gmt":"2025-06-11T20:49:34","guid":{"rendered":"https:\/\/www.zhaozhao123.cn\/php\/php-application-manual\/laravel\/1011.html"},"modified":"2025-06-12T04:49:34","modified_gmt":"2025-06-11T20:49:34","slug":"%e5%9c%a8-laravel-eloquent-%e4%b8%ad%e4%bd%bf%e7%94%a8left-join","status":"publish","type":"my1js","link":"https:\/\/www.zhaozhao123.cn\/php\/my1js\/1011.html","title":{"rendered":"\u5728 Laravel Eloquent \u4e2d\u4f7f\u7528\u2018LEFT JOIN\u2019"},"content":{"rendered":"
\r\n
\r\n
\r\n
\r\n
\r\n
\"Bug编译狮\"<\/figure>\r\n\r\n\r\n\r\n

Bug编译狮<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
\r\n
\r\n

在 Laravel Eloquent 中，你可以使用 leftJoin<\/code> 方法来实现左连接（Left Join）。这与 SQL 中的 LEFT JOIN<\/code> 语法相同。以下是一个示例，展示了如何在 Laravel Eloquent 中进行左连接：<\/p>\n

假设我们有两个模型：User<\/code> 和 Post<\/code>，并且它们之间通过 userId<\/code> 进行关联。<\/p>\n

1. 定义模型<\/h3>\n

首先，定义你的模型类：<\/p>\n

namespace AppModels;\n\nuse IlluminateDatabaseEloquentModel;\n\nclass User extends Model\n{\n    public function posts()\n    {\n        return $this->hasMany(Post::class, 'userId');\n    }\n}<\/code><\/pre>\n
2. 使用 leftJoin<\/code> 进行左连接<\/h3>\n
接下来，你在控制器或其他地方使用 leftJoin<\/code> 进行左连接：<\/p>\n
use AppModelsUser;\nuse AppModelsPost;\n\npublic function index()\n{\n    $users = User::with('posts')->get();\n\n    foreach ($users as $user) {\n        echo \"User: {$user->name}n\";\n        if ($user->posts->isEmpty()) {\n            echo \"No posts for this user.n\";\n        } else {\n            foreach ($user->posts as $post) {\n                echo \"- Post: {$post->title}n\";\n            }\n        }\n    }\n\n    return view('users.index', ['users' => $users]);\n}<\/code><\/pre>\n
3. 示例代码<\/h3>\n
如果你需要更详细的示例代码，可以参考以下完整示例：<\/p>\n
<?php\n\nnamespace AppHttpControllers;\n\nuse AppModelsUser;\nuse AppModelsPost;\n\nclass UserController extends Controller\n{\n    public function index()\n    {\n        \/\/ 使用 with 关键字进行 eager loading\n        $users = User::with('posts')->get();\n\n        foreach ($users as $user) {\n            echo \"User: {$user->name}n\";\n            if ($user->posts->isEmpty()) {\n                echo \"No posts for this user.n\";\n            } else {\n                foreach ($user->posts as $post) {\n                    echo \"- Post: {$post->title}n\";\n                }\n            }\n        }\n\n        return view('users.index', ['users' => $users]);\n    }\n}<\/code><\/pre>\n
在这个示例中，我们使用了 with<\/code> 方法来加载关联的 Post<\/code> 模型，并在视图中显示每个用户的帖子列表。如果用户没有帖子，则会显示“No posts for this user.”的消息。<\/p>\n
希望这个示例能帮助你理解在 Laravel Eloquent 中使用 leftJoin<\/code> 的方法。<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>
\r\n
\r\n
\r\n
\r\n
\r\n
\"黑板Bug讲师\"<\/figure>\r\n\r\n\r\n\r\n
黑板Bug讲师<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
\r\n
\r\n
介绍<\/h2>
Laravel，备受赞誉的PHP框架，为web开发者提供了一个优雅的对象关系映射（ORM）工具——Eloquent。其功能之一便是通过简洁的PHP语法构建高效的数据库查询。在本教程中，您将学习如何利用Laravel Eloquent中的“LEFT JOIN”SQL子句，并以多种示例进行展示，从基础到复杂场景都有涵盖。<\/p>
理解“左连接”（LEFT JOIN）<\/h3>
在深入探讨Eloquent的抽象之前，让我们先澄清一下“左连接”（LEFT JOIN）的作用。SQL中的“LEFT JOIN”用于将两个或多个表的行合并，基于它们之间的相关列，返回左表的所有记录和右表匹配的记录，如果找不到匹配项，则用NULL填充。<\/p>
设置我们的环境<\/h3>
为了跟随这些示例，确保您已经设置了一个Laravel项目。您应该在.env文件中配置数据库，并且已运行您希望连接的表的迁移。<\/p>
基本的LEFT JOIN在Eloquent中的实现方式。<\/h2>
使用Eloquent中的连接方法（joins）的起点是join方法，可以适配为进行“左连接”操作。让我们从一个简单的场景开始，该场景涉及用户和帖子表，并且你想获取所有用户及其帖子，如果有的话。\n\n首先，确保已安装了Laravel框架并创建了一个新项目。\n\n进入项目目录，运行以下命令初始化数据库：\nphp artisan migrate –seed\n\n创建两个模型：User 和 Post。\n\n在 app\/Models\/User.php 中定义 User 模型：\n<?php\n\nnamespace AppModels;\n\nuse IlluminateDatabaseEloquentFactoriesHasFactory;\nuse IlluminateFoundationAuthUser as Authenticatable;\nuse IlluminateNotificationsNotifiable;\n\nclass User extends Authenticatable\n{\n use HasFactory, Notifiable;\n\n \/**\n * The attributes that are mass assignable.\n *\n * @var array<int, string>\n *\/\n protected $fillable = [\n ‘name’, ’email’, ‘password’,\n ];\n\n \/**\n * The attributes that should be hidden for serialization.\n *\n * @var array<int, string>\n *\/\n protected $hidden = [\n ‘password’, ‘remember_token’,\n ];\n}\n\n在 app\/Models\/Post.php 中定义 Post 模型：\n<?php\n\nnamespace AppModels;\n\nuse IlluminateDatabaseEloquentFactoriesHasFactory;\nuse IlluminateFoundationAuthUser as Authenticatable;\nuse IlluminateNotificationsNotifiable;\n\nclass Post extends Authenticatable\n{\n use HasFactory, Notifiable;\n\n \/**\n * The attributes that are mass assignable.\n *\n * @var array<int, string>\n *\/\n protected $fillable = [\n ‘title’, ‘content’, ‘author_id’,\n ];\n\n \/**\n * The attributes that should be hidden for serialization.\n *\n * @var array<int, string>\n *\/\n protected $hidden = [];\n}\n\n定义关联关系：\n<?php\n\nnamespace AppModels;\n\nuse IlluminateDatabaseEloquentModel;\n\nclass User extends Authenticatable\n{\n public function posts()\n {\n return $this->hasMany(Post::class);\n }\n\n \/\/ 获取特定用户的帖子\n public function getPostsAttribute()\n {\n return collect($this->posts)->map(function ($post) {\n return [\n ‘id’ => $post->id,\n ‘title’ => $post->title,\n ‘content’ => $post->content,\n ‘created_at’ => $post->created_at,\n ];\n });\n }\n}\n\n在控制器中使用 with 方法来加载关联数据：\n<?php\n\nnamespace AppHttpControllers;\n\nuse AppModelsUser;\nuse AppModelsPost;\nuse IlluminateHttpRequest;\n\nclass UserController extends Controller\n{\n public function index(Request $request)\n {\n $users = User::with(‘posts’)->get();\n\n return response()->json([\n ‘success’ => true,\n ‘data’ => $users->toArray(),\n ]);\n }\n}\n\n使用路由访问 API：\n<?php\n\nuse IlluminateSupportFacadesRoute;\n\nRoute::resource(‘users’, UserController::class);\n\n测试 API 调用：\n使用工具如 Postman 或 curl 来测试 GET \/api\/users 端点。\n\n现在，你可以通过 GET \/api\/users 接口获取所有用户的帖子信息。如果有多个帖子，它们会以数组的形式返回。每个帖子包含 ID、标题、内容和发布时间。<\/p>
\/\/ Using the query builder\n$users = DB::table('users')\n   ->leftJoin('posts', 'users.id', '=', 'posts.user_id')\n   ->get();\n\/\/ Using Eloquent's relationship\n$users = User::with('posts')->get();<\/code><\/pre>
使用带筛选条件的左连接（LEFT JOIN）<\/h2>
实际上，你可能不需要从两个表中选择所有列。以下是使用Eloquent中的“LEFT JOIN”来选择特定列的方法。<\/p>
$users = DB::table('users')\n   ->leftJoin('posts', 'users.id', '=', 'posts.user_id')\n   ->select('users.name', 'posts.title')\n   ->get();<\/code><\/pre>
高级的“左连接”与条件子句<\/h2>
让我们增加一些条件语句，以便筛选出我们想要的结果。<\/p>
$users = User::leftJoin('posts', function($join) {\n   $join->on('users.id', '=', 'posts.user_id')\n   ->where('posts.created_at', '>', now()->subDays(7));\n})\n->get();<\/code><\/pre>
“LEFT JOIN” 与聚合函数<\/h2>
想象一下，想要拉取所有用户信息，并知道每个用户的帖子数量。这需要一个聚合函数，可以使用Eloquent来实现。<\/p>
$users = User::leftJoin('posts', 'users.id', '=', 'posts.user_id')\n   ->select('users.*', DB::raw('COUNT(posts.id) as posts_count'))\n   ->groupBy('users.id')\n   ->get();<\/code><\/pre>
多级“左连接”操作<\/h2>
在处理复杂的数据库模式时，为了获取跨越多个表的相关数据，可能需要执行多步的“左连接”操作（LEFT JOIN）。<\/p>
$users = User::leftJoin('posts', 'users.id', '=', 'posts.user_id')\n   ->leftJoin('comments', 'posts.id', '=', 'comments.post_id')\n   ->select('users.name', 'posts.title', DB::raw('COUNT(comments.id) as comments_count'))\n   ->groupBy('users.id', 'posts.id')\n   ->get();<\/code><\/pre>
结论。<\/h2>
在关于使用 LEFT JOIN 的 Laravel Eloquent 教程中，我们已经涵盖了如何执行基本连接、选择特定列、添加条件语句、包括聚合函数以及执行多级连接。Eloquent 提供的灵活性允许您构建复杂的查询，同时保持您的 Laravel 应用程序中的简洁性和优雅性。<\/p><\/body>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>
\r\n
\r\n
\r\n
\r\n
\r\n
\"长工码奴1523\"<\/figure>\r\n\r\n\r\n\r\n
长工码奴1523<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
\r\n
\r\n
在Laravel框架的Eloquent ORM（对象关系映射）中，LEFT JOIN<\/code> 是一种连接操作，用于返回两个表中的所有行，但不包括那些在第一个表中没有对应记录的行。<\/p>\n
以下是如何在Laravel Eloquent模型中使用LEFT JOIN<\/code>的示例：<\/p>\n
use AppModelsUser;\nuse IlluminateDatabaseEloquentRelationsHasMany;\n\nclass User extends Model\n{\n    public function posts()\n    {\n        return $this->hasMany('AppModelsPost');\n    }\n\n    \/\/ 使用 LEFT JOIN\n    public function getPostsCountAttribute()\n    {\n        return $this->posts()->count();\n    }\n}<\/code><\/pre>\n
在这个例子中，我们定义了一个User<\/code>模型，它有一个posts<\/code>关联到Post<\/code>模型。然后我们在User<\/code>模型的getPostsCountAttribute<\/code>方法中实现了hasMany<\/code>方法，并使用了LEFT JOIN<\/code>来获取用户的所有帖子数量。<\/p>\n
这将返回用户的帖子总数，即使该用户没有任何帖子。这样可以让我们了解用户是否有任何未发布的帖子。<\/p>\n
请注意，这个例子假设你的User<\/code>模型有posts<\/code>关联，并且已经设置了正确的查询构造器。如果你需要更详细的解释，请告诉我！<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Bug编译狮 在 Laravel Eloquent 中，你可以使用 leftJoin 方法来实现..<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","meta":{"_acf_changed":false},"tags":[],"my1js2nav":[44],"tuisongtax":[],"class_list":["post-1011","my1js","type-my1js","status-publish","hentry","my1js2nav-laravel"],"acf":{"qian_art_seotitle":"","qian_art_seotitle_source":{"label":"SEO\u6807\u9898","type":"text","formatted_value":""},"qian_art_seokws":"","qian_art_seokws_source":{"label":"SEO\u5173\u952e\u8bcd","type":"text","formatted_value":""},"qian_art_stzhong":"","qian_art_stzhong_source":{"label":"\u4e2d | \u77ed\u6807\u9898","type":"text","formatted_value":""}},"_links":{"self":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js\/1011","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js"}],"about":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/types\/my1js"}],"author":[{"embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/media?parent=1011"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tags?post=1011"},{"taxonomy":"my1js2nav","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js2nav?post=1011"},{"taxonomy":"tuisongtax","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tuisongtax?post=1011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}