{"id":2611,"date":"2025-03-24T08:46:56","date_gmt":"2025-03-23T23:46:56","guid":{"rendered":"https:\/\/dexall.co.jp\/articles\/?p=2611"},"modified":"2025-03-24T08:47:25","modified_gmt":"2025-03-23T23:47:25","slug":"%e3%80%90%e4%bf%9d%e5%ad%98%e7%89%88%e3%80%91laravel%e3%81%aehasmany%e3%83%aa%e3%83%ac%e3%83%bc%e3%82%b7%e3%83%a7%e3%83%b3%e5%ae%8c%e5%85%a8%e3%82%ac%e3%82%a4%e3%83%89-%e5%ae%9f%e8%a3%85%e4%be%8b","status":"publish","type":"post","link":"https:\/\/dexall.co.jp\/articles\/?p=2611","title":{"rendered":"\u3010\u4fdd\u5b58\u7248\u3011Laravel\u306ehasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5b8c\u5168\u30ac\u30a4\u30c9 &#8211; \u5b9f\u88c5\u4f8b\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b915\u9078"},"content":{"rendered":"\n<div class=\"toc\"><br \/>\n<b>Warning<\/b>:  Undefined array key \"is_admin\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>116<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_category_top\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>121<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_top\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>128<\/b><br \/>\n    <div id=\"toc_container\" class=\"sgb-toc--bullets js-smooth-scroll\" data-dialog-title=\"\u76ee\u6b21\">\n      <p class=\"toc_title\">\u76ee\u6b21 <\/p>\n      <ul class=\"toc_list\">  <li class=\"first\">    <a href=\"#i-0\">Laravel\u306ehasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3068\u306f<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-1\">1\u5bfe\u591a\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3092\u5b9f\u73fe\u3059\u308b\u91cd\u8981\u306a\u6a5f\u80fd<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-2\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u8a08\u306b\u304a\u3051\u308b\u6d3b\u7528\u30b7\u30fc\u30f3<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-3\">hasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u57fa\u672c\u7684\u306a\u5b9f\u88c5\u65b9\u6cd5<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-4\">\u30e2\u30c7\u30eb\u30af\u30e9\u30b9\u3067\u306e\u5b9a\u7fa9\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-5\">\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u306e\u8a2d\u5b9a<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-6\">\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u65b9\u6cd5<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-7\">\u5b9f\u8df5\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b95\u9078<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-8\">\u30d6\u30ed\u30b0\u8a18\u4e8b\u3068\u30b3\u30e1\u30f3\u30c8\u306e\u95a2\u9023\u4ed8\u3051<\/a>      <\/li>      <li>        <a href=\"#i-9\">\u30e6\u30fc\u30b6\u30fc\u3068\u6295\u7a3f\u306e\u7ba1\u7406<\/a>      <\/li>      <li>        <a href=\"#i-10\">\u6ce8\u6587\u3068\u6ce8\u6587\u8a73\u7d30\u306e\u5b9f\u88c5<\/a>      <\/li>      <li>        <a href=\"#i-11\">\u30ab\u30c6\u30b4\u30ea\u30fc\u3068\u5546\u54c1\u306e\u95a2\u9023\u4ed8\u3051<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-12\">\u7d44\u7e54\u3068\u5f93\u696d\u54e1\u306e\u7ba1\u7406<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-13\">hasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u9ad8\u5ea6\u306a\u4f7f\u3044\u65b9<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-14\">\u6761\u4ef6\u4ed8\u304d\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u5b9f\u88c5<\/a>      <\/li>      <li>        <a href=\"#i-15\">\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3068\u5236\u7d04\u306e\u8a2d\u5b9a<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-16\">\u30ab\u30b9\u30bf\u30e0\u30af\u30a8\u30ea\u306e\u8ffd\u52a0\u65b9\u6cd5<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-17\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-18\">Eager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\u306e\u9069\u5207\u306a\u4f7f\u7528<\/a>      <\/li>      <li>        <a href=\"#i-19\">\u30af\u30a8\u30ea\u306e\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-20\">N+1\u554f\u984c\u306e\u56de\u907f\u65b9\u6cd5<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-21\">\u3088\u304f\u3042\u308b\u30c8\u30e9\u30d6\u30eb\u3068\u89e3\u6c7a\u65b9\u6cd5<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-22\">\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u304c\u6b63\u3057\u304f\u52d5\u4f5c\u3057\u306a\u3044\u5834\u5408\u306e\u5bfe\u51e6\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-23\">\u30c7\u30fc\u30bf\u6574\u5408\u6027\u306e\u78ba\u4fdd\u65b9\u6cd5<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-24\">\u5faa\u74b0\u53c2\u7167\u306e\u9632\u6b62\u7b56<\/a>      <\/li>    <\/ul>  <\/li>  <li class=\"last\">    <a href=\"#i-25\">\u95a2\u9023\u3059\u308b\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30bf\u30a4\u30d7\u3068\u306e\u4f7f\u3044\u5206\u3051<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-26\">belongsTo\u3068hasMany\u306e\u9055\u3044<\/a>      <\/li>      <li>        <a href=\"#i-27\">hasManyThrough\u306e\u6d3b\u7528\u30b7\u30fc\u30f3<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-28\">\u9069\u5207\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30bf\u30a4\u30d7\u306e\u9078\u629e\u65b9\u6cd5<\/a>      <\/li>    <\/ul>  <\/li><\/ul>\n      <a href=\"#\" class=\"sgb-toc-button js-toc-button\" rel=\"nofollow\" data-open-dialog=\"true\"><i class=\"fa fa-list\"><\/i><span class=\"sgb-toc-button__text\">\u76ee\u6b21\u3078<\/span><\/a>\n    <\/div><\/div><h2 class=\"wp-block-heading\" id=\"i-0\">Laravel\u306ehasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3068\u306f<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-1\">1\u5bfe\u591a\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3092\u5b9f\u73fe\u3059\u308b\u91cd\u8981\u306a\u6a5f\u80fd<\/h3>\n\n\n\n<p>Laravel\u306ehasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u9593\u306e1\u5bfe\u591a\uff08one-to-many\uff09\u306e\u95a2\u4fc2\u3092\u7c21\u5358\u306b\u5b9f\u88c5\u3067\u304d\u308b\u5f37\u529b\u306a\u6a5f\u80fd\u3067\u3059\u3002\u3053\u306e\u95a2\u4fc2\u3067\u306f\u30011\u3064\u306e\u30e2\u30c7\u30eb\u304c\u4ed6\u306e\u8907\u6570\u306e\u30e2\u30c7\u30eb\u3092\u300c\u6240\u6709\u300d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305f\u3068\u3048\u3070\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1\u4eba\u306e\u30e6\u30fc\u30b6\u30fc\u304c\u8907\u6570\u306e\u6295\u7a3f\u3092\u6301\u3064<\/li>\n\n\n\n<li>1\u3064\u306e\u30d6\u30ed\u30b0\u304c\u8907\u6570\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u6301\u3064<\/li>\n\n\n\n<li>1\u3064\u306e\u6ce8\u6587\u304c\u8907\u6570\u306e\u6ce8\u6587\u660e\u7d30\u3092\u6301\u3064<\/li>\n<\/ul>\n\n\n\n<p>\u5b9f\u88c5\u4f8b\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class User extends Model\n{\n    public function posts()\n    {\n        return $this-&gt;hasMany(Post::class);\n    }\n}<\/pre>\n\n\n\n<p>\u3053\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u5b9a\u7fa9\u3059\u308b\u3053\u3068\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u76f4\u611f\u7684\u306a\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">$user = User::find(1);\n$userPosts = $user-&gt;posts;  \/\/ \u30e6\u30fc\u30b6\u30fc\u306e\u5168\u6295\u7a3f\u3092\u53d6\u5f97<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-2\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u8a08\u306b\u304a\u3051\u308b\u6d3b\u7528\u30b7\u30fc\u30f3<\/h3>\n\n\n\n<p>hasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u8a08\u30d1\u30bf\u30fc\u30f3\u3067\u7279\u306b\u6709\u7528\u3067\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u968e\u5c64\u69cb\u9020\u306e\u8868\u73fe<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u90e8\u9580\u3068\u5f93\u696d\u54e1<\/li>\n\n\n\n<li>\u30ab\u30c6\u30b4\u30ea\u30fc\u3068\u5546\u54c1<\/li>\n\n\n\n<li>\u30d5\u30a9\u30eb\u30c0\u3068\u30d5\u30a1\u30a4\u30eb<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u30c7\u30fc\u30bf\u306e\u7ba1\u7406<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6ce8\u6587\u3068\u6ce8\u6587\u660e\u7d30<\/li>\n\n\n\n<li>\u8acb\u6c42\u66f8\u3068\u8acb\u6c42\u660e\u7d30<\/li>\n\n\n\n<li>\u4e88\u7d04\u3068\u4e88\u7d04\u8a73\u7d30<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30e6\u30fc\u30b6\u30fc\u30b3\u30f3\u30c6\u30f3\u30c4\u306e\u7ba1\u7406<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30e6\u30fc\u30b6\u30fc\u3068\u6295\u7a3f<\/li>\n\n\n\n<li>\u30d6\u30ed\u30b0\u3068\u8a18\u4e8b<\/li>\n\n\n\n<li>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3068\u30bf\u30b9\u30af<\/li>\n<\/ul>\n\n\n\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u8a08\u6642\u306e\u91cd\u8981\u306a\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5b50\u30c6\u30fc\u30d6\u30eb\u306b\u306f\u5fc5\u305a\u5916\u90e8\u30ad\u30fc\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n\n\n\n<li>\u5916\u90e8\u30ad\u30fc\u306b\u306f\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4ed8\u4e0e\u3059\u308b<\/li>\n\n\n\n<li>\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u30ab\u30b9\u30b1\u30fc\u30c9\u524a\u9664\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n<\/ul>\n\n\n\n<p>\u4f8b\uff1a\u30e6\u30fc\u30b6\u30fc\u3068\u6295\u7a3f\u306e\u30c6\u30fc\u30d6\u30eb\u8a2d\u8a08<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30e6\u30fc\u30b6\u30fc\u30c6\u30fc\u30d6\u30eb\u306e\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\nSchema::create('users', function (Blueprint $table) {\n    $table-&gt;id();\n    $table-&gt;string('name');\n    $table-&gt;timestamps();\n});\n\n\/\/ \u6295\u7a3f\u30c6\u30fc\u30d6\u30eb\u306e\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\nSchema::create('posts', function (Blueprint $table) {\n    $table-&gt;id();\n    $table-&gt;foreignId('user_id')-&gt;constrained()-&gt;onDelete('cascade');\n    $table-&gt;string('title');\n    $table-&gt;text('content');\n    $table-&gt;timestamps();\n});<\/pre>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u3001hasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u95a2\u9023\u30c7\u30fc\u30bf\u306e\u7ba1\u7406\u304c\u5bb9\u6613\u306b\u306a\u308a\u3001\u30b3\u30fc\u30c9\u306e\u53ef\u8aad\u6027\u3068\u4fdd\u5b88\u6027\u304c\u5411\u4e0a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-3\">hasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u57fa\u672c\u7684\u306a\u5b9f\u88c5\u65b9\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-4\">\u30e2\u30c7\u30eb\u30af\u30e9\u30b9\u3067\u306e\u5b9a\u7fa9\u65b9\u6cd5<\/h3>\n\n\n\n<p>hasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u88c5\u3059\u308b\u306b\u306f\u3001\u89aa\u30e2\u30c7\u30eb\u3068\u5b50\u30e2\u30c7\u30eb\u306e\u4e21\u65b9\u3067\u9069\u5207\u306a\u95a2\u4fc2\u3092\u5b9a\u7fa9\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u4ee5\u4e0b\u306b\u3001\u57fa\u672c\u7684\u306a\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u3092\u793a\u3057\u307e\u3059\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u89aa\u30e2\u30c7\u30eb\uff08User.php\uff09\nclass User extends Model\n{\n    public function posts()\n    {\n        \/\/ \u57fa\u672c\u7684\u306a\u5b9a\u7fa9\n        return $this-&gt;hasMany(Post::class);\n\n        \/\/ \u30ab\u30b9\u30bf\u30e0\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\n        \/\/ return $this-&gt;hasMany(Post::class, 'author_id', 'id');\n    }\n}\n\n\/\/ \u5b50\u30e2\u30c7\u30eb\uff08Post.php\uff09\nclass Post extends Model\n{\n    public function user()\n    {\n        return $this-&gt;belongsTo(User::class);\n    }\n}<\/pre>\n\n\n\n<p>\u91cd\u8981\u306a\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30e1\u30bd\u30c3\u30c9\u540d\u306f\u8907\u6570\u5f62\u304c\u63a8\u5968\uff08posts, comments \u306a\u3069\uff09<\/li>\n\n\n\n<li>\u623b\u308a\u5024\u306e\u578b\u306f\u5e38\u306b<code>HasMany<\/code>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9<\/li>\n\n\n\n<li>\u5916\u90e8\u30ad\u30fc\u306f\u898f\u7d04\u306b\u5f93\u3048\u3070\u81ea\u52d5\u7684\u306b\u8a2d\u5b9a\u3055\u308c\u308b<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-5\">\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u306e\u8a2d\u5b9a<\/h3>\n\n\n\n<p>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u6b63\u3057\u304f\u6a5f\u80fd\u3055\u305b\u308b\u306b\u306f\u3001\u9069\u5207\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u69cb\u9020\u304c\u5fc5\u8981\u3067\u3059\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30e6\u30fc\u30b6\u30fc\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\nclass CreateUsersTable extends Migration\n{\n    public function up()\n    {\n        Schema::create('users', function (Blueprint $table) {\n            $table-&gt;id();\n            $table-&gt;string('name');\n            $table-&gt;string('email')-&gt;unique();\n            $table-&gt;timestamps();\n        });\n    }\n}\n\n\/\/ \u6295\u7a3f\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\nclass CreatePostsTable extends Migration\n{\n    public function up()\n    {\n        Schema::create('posts', function (Blueprint $table) {\n            $table-&gt;id();\n            \/\/ \u5916\u90e8\u30ad\u30fc\u306e\u8a2d\u5b9a\n            $table-&gt;foreignId('user_id')\n                  -&gt;constrained()\n                  -&gt;onDelete('cascade');\n            $table-&gt;string('title');\n            $table-&gt;text('content');\n            $table-&gt;timestamps();\n        });\n    }\n}<\/pre>\n\n\n\n<p>\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u8a2d\u5b9a\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5fc5\u305a\u5916\u90e8\u30ad\u30fc\u5236\u7d04\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4ed8\u4e0e\u3059\u308b<\/li>\n\n\n\n<li>\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u30ab\u30b9\u30b1\u30fc\u30c9\u524a\u9664\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-6\">\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u65b9\u6cd5<\/h3>\n\n\n\n<p>hasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u53d6\u5f97\u306b\u306f\u3001\u8907\u6570\u306e\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u57fa\u672c\u7684\u306a\u53d6\u5f97\u65b9\u6cd5<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30e6\u30fc\u30b6\u30fc\u306e\u5168\u6295\u7a3f\u3092\u53d6\u5f97\n$user = User::find(1);\n$posts = $user-&gt;posts;\n\n\/\/ \u7279\u5b9a\u306e\u6761\u4ef6\u3067\u7d5e\u308a\u8fbc\u307f\n$publishedPosts = $user-&gt;posts()-&gt;where('status', 'published')-&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Eager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\u3092\u4f7f\u7528\u3057\u305f\u52b9\u7387\u7684\u306a\u53d6\u5f97<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ N+1\u554f\u984c\u3092\u56de\u907f\n$users = User::with('posts')-&gt;get();\nforeach ($users as $user) {\n    foreach ($user-&gt;posts as $post) {\n        echo $post-&gt;title;\n    }\n}<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u305f\u65b0\u898f\u30ec\u30b3\u30fc\u30c9\u306e\u4f5c\u6210<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u5358\u4e00\u30ec\u30b3\u30fc\u30c9\u306e\u4f5c\u6210\n$user-&gt;posts()-&gt;create([\n    'title' =&gt; '\u65b0\u3057\u3044\u6295\u7a3f',\n    'content' =&gt; '\u6295\u7a3f\u5185\u5bb9'\n]);\n\n\/\/ \u8907\u6570\u30ec\u30b3\u30fc\u30c9\u306e\u4f5c\u6210\n$user-&gt;posts()-&gt;createMany([\n    ['title' =&gt; '\u6295\u7a3f1', 'content' =&gt; '\u5185\u5bb91'],\n    ['title' =&gt; '\u6295\u7a3f2', 'content' =&gt; '\u5185\u5bb92']\n]);<\/pre>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li><strong>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u305f\u96c6\u8a08<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u6295\u7a3f\u6570\u306e\u53d6\u5f97\n$userWithPostCount = User::withCount('posts')-&gt;get();\nforeach ($userWithPostCount as $user) {\n    echo $user-&gt;posts_count;\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u57fa\u672c\u7684\u306a\u5b9f\u88c5\u65b9\u6cd5\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u3067\u3001Laravel\u958b\u767a\u3067\u306e\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u7ba1\u7406\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u3088\u308a\u5b9f\u8df5\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-7\">\u5b9f\u8df5\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b95\u9078<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-8\">\u30d6\u30ed\u30b0\u8a18\u4e8b\u3068\u30b3\u30e1\u30f3\u30c8\u306e\u95a2\u9023\u4ed8\u3051<\/h3>\n\n\n\n<p>\u30d6\u30ed\u30b0\u30b7\u30b9\u30c6\u30e0\u3067\u306f\u30011\u3064\u306e\u8a18\u4e8b\u306b\u5bfe\u3057\u3066\u8907\u6570\u306e\u30b3\u30e1\u30f3\u30c8\u304c\u7d10\u3065\u304f\u3068\u3044\u3046\u5178\u578b\u7684\u306a1\u5bfe\u591a\u306e\u95a2\u4fc2\u304c\u767a\u751f\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Article.php\nclass Article extends Model\n{\n    public function comments()\n    {\n        return $this-&gt;hasMany(Comment::class)\n                    -&gt;orderBy('created_at', 'desc'); \/\/ \u65b0\u3057\u3044\u30b3\u30e1\u30f3\u30c8\u9806\n    }\n\n    \/\/ \u30a2\u30af\u30c6\u30a3\u30d6\u306a\u30b3\u30e1\u30f3\u30c8\u306e\u307f\u3092\u53d6\u5f97\u3059\u308b\u30b9\u30b3\u30fc\u30d7\u4ed8\u304d\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n    public function activeComments()\n    {\n        return $this-&gt;hasMany(Comment::class)\n                    -&gt;where('status', 'active');\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\n$article = Article::find(1);\n$recentComments = $article-&gt;comments()-&gt;take(5)-&gt;get(); \/\/ \u6700\u65b05\u4ef6\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u53d6\u5f97<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-9\">\u30e6\u30fc\u30b6\u30fc\u3068\u6295\u7a3f\u306e\u7ba1\u7406<\/h3>\n\n\n\n<p>SNS\u3084\u30d6\u30ed\u30b0\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u3088\u304f\u898b\u3089\u308c\u308b\u3001\u30e6\u30fc\u30b6\u30fc\u3068\u6295\u7a3f\u306e\u95a2\u4fc2\u3092\u5b9f\u88c5\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ User.php\nclass User extends Model\n{\n    public function posts()\n    {\n        return $this-&gt;hasMany(Post::class);\n    }\n\n    \/\/ \u516c\u958b\u6e08\u307f\u6295\u7a3f\u306e\u307f\u3092\u53d6\u5f97\u3059\u308b\u30e1\u30bd\u30c3\u30c9\n    public function publishedPosts()\n    {\n        return $this-&gt;hasMany(Post::class)\n                    -&gt;where('status', 'published')\n                    -&gt;orderBy('published_at', 'desc');\n    }\n}\n\n\/\/ \u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u3067\u306e\u4f7f\u7528\u4f8b\npublic function userProfile($userId)\n{\n    $user = User::with(['posts' =&gt; function($query) {\n        $query-&gt;where('status', 'published')\n              -&gt;select('id', 'user_id', 'title', 'published_at')\n              -&gt;latest()\n              -&gt;take(10);\n    }])-&gt;findOrFail($userId);\n\n    return view('profile', compact('user'));\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-10\">\u6ce8\u6587\u3068\u6ce8\u6587\u8a73\u7d30\u306e\u5b9f\u88c5<\/h3>\n\n\n\n<p>EC\u30b5\u30a4\u30c8\u3067\u306e\u6ce8\u6587\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\u306b\u304a\u3051\u308b\u5b9f\u88c5\u4f8b\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Order.php\nclass Order extends Model\n{\n    public function orderItems()\n    {\n        return $this-&gt;hasMany(OrderItem::class);\n    }\n\n    \/\/ \u6ce8\u6587\u5408\u8a08\u91d1\u984d\u3092\u8a08\u7b97\u3059\u308b\u30e1\u30bd\u30c3\u30c9\n    public function calculateTotal()\n    {\n        return $this-&gt;orderItems-&gt;sum(function($item) {\n            return $item-&gt;quantity * $item-&gt;price;\n        });\n    }\n}\n\n\/\/ \u6ce8\u6587\u4f5c\u6210\u306e\u4f8b\npublic function createOrder(Request $request)\n{\n    DB::transaction(function() use ($request) {\n        $order = Order::create([\n            'user_id' =&gt; auth()-&gt;id(),\n            'status' =&gt; 'pending'\n        ]);\n\n        \/\/ \u30ab\u30fc\u30c8\u306e\u5546\u54c1\u3092\u6ce8\u6587\u8a73\u7d30\u3068\u3057\u3066\u767b\u9332\n        foreach($request-&gt;items as $item) {\n            $order-&gt;orderItems()-&gt;create([\n                'product_id' =&gt; $item['product_id'],\n                'quantity' =&gt; $item['quantity'],\n                'price' =&gt; $item['price']\n            ]);\n        }\n    });\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-11\">\u30ab\u30c6\u30b4\u30ea\u30fc\u3068\u5546\u54c1\u306e\u95a2\u9023\u4ed8\u3051<\/h3>\n\n\n\n<p>EC\u30b5\u30a4\u30c8\u3084\u30b3\u30f3\u30c6\u30f3\u30c4\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\u3067\u306e\u30ab\u30c6\u30b4\u30ea\u30fc\u7ba1\u7406\u306e\u5b9f\u88c5\u4f8b\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Category.php\nclass Category extends Model\n{\n    public function products()\n    {\n        return $this-&gt;hasMany(Product::class);\n    }\n\n    \/\/ \u5728\u5eab\u306e\u3042\u308b\u5546\u54c1\u306e\u307f\u3092\u53d6\u5f97\n    public function availableProducts()\n    {\n        return $this-&gt;hasMany(Product::class)\n                    -&gt;where('stock', '&gt;', 0)\n                    -&gt;where('status', 'active');\n    }\n}\n\n\/\/ \u5546\u54c1\u4e00\u89a7\u8868\u793a\u306e\u4f8b\npublic function categoryProducts($categoryId)\n{\n    $category = Category::with(['products' =&gt; function($query) {\n        $query-&gt;where('status', 'active')\n              -&gt;with('images')  \/\/ \u5546\u54c1\u753b\u50cf\u3082\u540c\u6642\u306b\u53d6\u5f97\n              -&gt;paginate(20);\n    }])-&gt;findOrFail($categoryId);\n\n    return view('category.products', compact('category'));\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-12\">\u7d44\u7e54\u3068\u5f93\u696d\u54e1\u306e\u7ba1\u7406<\/h3>\n\n\n\n<p>\u4f01\u696d\u306e\u4eba\u4e8b\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\u306b\u304a\u3051\u308b\u5b9f\u88c5\u4f8b\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Department.php\nclass Department extends Model\n{\n    public function employees()\n    {\n        return $this-&gt;hasMany(Employee::class);\n    }\n\n    \/\/ \u5f79\u8077\u3054\u3068\u306e\u5f93\u696d\u54e1\u3092\u53d6\u5f97\n    public function managers()\n    {\n        return $this-&gt;hasMany(Employee::class)\n                    -&gt;where('position', 'manager');\n    }\n\n    \/\/ \u90e8\u7f72\u306e\u4eba\u4ef6\u8cbb\u3092\u8a08\u7b97\n    public function calculateTotalSalary()\n    {\n        return $this-&gt;employees-&gt;sum('salary');\n    }\n}\n\n\/\/ \u90e8\u7f72\u60c5\u5831\u306e\u53d6\u5f97\u4f8b\npublic function departmentSummary($departmentId)\n{\n    $department = Department::with(['employees' =&gt; function($query) {\n        $query-&gt;select('id', 'department_id', 'name', 'position', 'salary')\n              -&gt;orderBy('position')\n              -&gt;orderBy('joined_at');\n    }])\n    -&gt;withCount('employees')\n    -&gt;findOrFail($departmentId);\n\n    $summary = [\n        'total_employees' =&gt; $department-&gt;employees_count,\n        'total_salary' =&gt; $department-&gt;calculateTotalSalary(),\n        'manager_count' =&gt; $department-&gt;managers()-&gt;count()\n    ];\n\n    return view('department.summary', compact('department', 'summary'));\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u5b9f\u88c5\u4f8b\u306f\u3001\u5b9f\u969b\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u3059\u3050\u306b\u6d3b\u7528\u3067\u304d\u308b\u5f62\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u5404\u4f8b\u3067\u306f\u3001\u5358\u7d14\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5b9a\u7fa9\u3060\u3051\u3067\u306a\u304f\u3001\u5b9f\u52d9\u3067\u5fc5\u8981\u3068\u306a\u308b\u8ffd\u52a0\u6a5f\u80fd\u3084\u6700\u9069\u5316\u624b\u6cd5\u3082\u542b\u3081\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-13\">hasMany\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u9ad8\u5ea6\u306a\u4f7f\u3044\u65b9<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-14\">\u6761\u4ef6\u4ed8\u304d\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u5b9f\u88c5<\/h3>\n\n\n\n<p>\u6761\u4ef6\u4ed8\u304d\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u7279\u5b9a\u306e\u6761\u4ef6\u306b\u57fa\u3065\u3044\u3066\u95a2\u9023\u30c7\u30fc\u30bf\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ User.php\nclass User extends Model\n{\n    \/\/ \u516c\u958b\u6e08\u307f\u306e\u6295\u7a3f\u306e\u307f\u3092\u53d6\u5f97\u3059\u308b\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n    public function publishedPosts()\n    {\n        return $this-&gt;hasMany(Post::class)\n                    -&gt;where('status', 'published')\n                    -&gt;where('published_at', '&lt;=', now());\n    }\n\n    \/\/ \u904e\u53bb30\u65e5\u4ee5\u5185\u306e\u6295\u7a3f\u3092\u53d6\u5f97\u3059\u308b\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n    public function recentPosts()\n    {\n        return $this-&gt;hasMany(Post::class)\n                    -&gt;whereBetween('created_at', [\n                        now()-&gt;subDays(30),\n                        now()\n                    ]);\n    }\n\n    \/\/ \u8907\u6570\u306e\u6761\u4ef6\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n    public function popularPosts()\n    {\n        return $this-&gt;hasMany(Post::class)\n                    -&gt;where('status', 'published')\n                    -&gt;where('views_count', '&gt;=', 1000)\n                    -&gt;orderBy('views_count', 'desc');\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\n$user = User::find(1);\n$trendingPosts = $user-&gt;popularPosts()-&gt;take(5)-&gt;get();<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-15\">\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3068\u5236\u7d04\u306e\u8a2d\u5b9a<\/h3>\n\n\n\n<p>\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5b9a\u7fa9\u6642\u306b\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3084\u5236\u7d04\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u306e\u6574\u5408\u6027\u3092\u4fdd\u3064\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Category.php\nclass Category extends Model\n{\n    \/\/ \u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u4e26\u3073\u9806\u3092\u8a2d\u5b9a\u3057\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n    public function products()\n    {\n        return $this-&gt;hasMany(Product::class)\n                    -&gt;orderBy('sort_order')\n                    -&gt;orderBy('name');\n    }\n\n    \/\/ \u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3092\u6301\u3064\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\n    public function newProducts()\n    {\n        return $this-&gt;hasMany(Product::class)\n                    -&gt;withDefault([\n                        'status' =&gt; 'draft',\n                        'stock' =&gt; 0,\n                        'price' =&gt; 0\n                    ]);\n    }\n}\n\n\/\/ \u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u5236\u7d04\u8a2d\u5b9a\nSchema::create('products', function (Blueprint $table) {\n    $table-&gt;id();\n    $table-&gt;foreignId('category_id')\n          -&gt;constrained()\n          -&gt;onDelete('restrict')  \/\/ \u30ab\u30c6\u30b4\u30ea\u30fc\u306e\u524a\u9664\u3092\u5236\u9650\n          -&gt;onUpdate('cascade');  \/\/ \u30ab\u30c6\u30b4\u30ea\u30fcID\u306e\u66f4\u65b0\u3092\u4f1d\u64ad\n    $table-&gt;string('name');\n    $table-&gt;integer('sort_order')-&gt;default(0);\n    $table-&gt;timestamps();\n});<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-16\">\u30ab\u30b9\u30bf\u30e0\u30af\u30a8\u30ea\u306e\u8ffd\u52a0\u65b9\u6cd5<\/h3>\n\n\n\n<p>\u8907\u96d1\u306a\u6761\u4ef6\u3084\u30ab\u30b9\u30bf\u30e0\u30ed\u30b8\u30c3\u30af\u3092\u6301\u3064\u30af\u30a8\u30ea\u3092\u8ffd\u52a0\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Order.php\nclass Order extends Model\n{\n    public function items()\n    {\n        return $this-&gt;hasMany(OrderItem::class)\n                    -&gt;withSum('discounts', 'amount')  \/\/ \u5272\u5f15\u984d\u306e\u5408\u8a08\u3092\u53d6\u5f97\n                    -&gt;withCount('reviews');           \/\/ \u30ec\u30d3\u30e5\u30fc\u6570\u3092\u53d6\u5f97\n    }\n\n    \/\/ \u30b9\u30b3\u30fc\u30d7\u3092\u4f7f\u7528\u3057\u305f\u30ab\u30b9\u30bf\u30e0\u30af\u30a8\u30ea\n    public function scopeWithTotalAmount($query)\n    {\n        return $query-&gt;withSum('items', 'amount')\n                    -&gt;withSum('items', 'tax_amount');\n    }\n\n    \/\/ \u8907\u96d1\u306a\u96c6\u8a08\u3092\u884c\u3046\u30ab\u30b9\u30bf\u30e0\u30af\u30a8\u30ea\n    public function itemsWithAnalytics()\n    {\n        return $this-&gt;hasMany(OrderItem::class)\n                    -&gt;select([\n                        'order_items.*',\n                        DB::raw('(price * quantity) as subtotal'),\n                        DB::raw('((price * quantity) * (tax_rate \/ 100)) as tax_amount')\n                    ])\n                    -&gt;with(['product' =&gt; function($query) {\n                        $query-&gt;select('id', 'name', 'category_id')\n                              -&gt;with('category:id,name');\n                    }]);\n    }\n}\n\n\/\/ \u9ad8\u5ea6\u306a\u4f7f\u7528\u4f8b\n$orders = Order::with(['items' =&gt; function($query) {\n    $query-&gt;where('status', 'shipped')\n          -&gt;whereHas('product', function($q) {\n              $q-&gt;where('category_id', request('category_id'));\n          })\n          -&gt;withSum('discounts', 'amount')\n          -&gt;orderBy('created_at', 'desc');\n}])\n-&gt;withTotalAmount()\n-&gt;paginate(20);\n\n\/\/ \u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u3092\u4f7f\u7528\u3057\u305f\u52d5\u7684\u306a\u6761\u4ef6\u8ffd\u52a0\npublic function getFilteredOrders(Request $request)\n{\n    $query = Order::query();\n\n    \/\/ \u52d5\u7684\u306a\u6761\u4ef6\u8ffd\u52a0\n    if ($request-&gt;has('status')) {\n        $query-&gt;whereHas('items', function($q) use ($request) {\n            $q-&gt;where('status', $request-&gt;status);\n        });\n    }\n\n    if ($request-&gt;has('category_id')) {\n        $query-&gt;whereHas('items.product', function($q) use ($request) {\n            $q-&gt;where('category_id', $request-&gt;category_id);\n        });\n    }\n\n    \/\/ \u5fc5\u8981\u306a\u95a2\u9023\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30c9\n    return $query-&gt;with([\n        'items' =&gt; function($query) {\n            $query-&gt;with('product.category')\n                  -&gt;withSum('discounts', 'amount');\n        }\n    ])\n    -&gt;withTotalAmount()\n    -&gt;latest()\n    -&gt;paginate(20);\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u9ad8\u5ea6\u306a\u4f7f\u3044\u65b9\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u67d4\u8edf\u3067\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u64cd\u4f5c\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u8907\u96d1\u306a\u30af\u30a8\u30ea\u306f\u6027\u80fd\u306b\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u305f\u3081\u3001\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u5b9a\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u76e3\u8996\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-17\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-18\">Eager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\u306e\u9069\u5207\u306a\u4f7f\u7528<\/h3>\n\n\n\n<p>Eager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\u306f\u3001N+1\u554f\u984c\u3092\u89e3\u6c7a\u3059\u308b\u91cd\u8981\u306a\u6a5f\u80fd\u3067\u3059\u304c\u3001\u9069\u5207\u306b\u4f7f\u7528\u3057\u306a\u3044\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u4f4e\u4e0b\u3092\u62db\u304f\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u60aa\u3044\u4f8b\uff1aN+1\u554f\u984c\u304c\u767a\u751f\n$users = User::all();\nforeach ($users as $user) {\n    echo $user-&gt;posts-&gt;count(); \/\/ \u5404\u30e6\u30fc\u30b6\u30fc\u3054\u3068\u306b\u8ffd\u52a0\u306e\u30af\u30a8\u30ea\u304c\u767a\u751f\n}\n\n\/\/ \u826f\u3044\u4f8b\uff1aEager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\u3092\u4f7f\u7528\n$users = User::withCount('posts')-&gt;get();\nforeach ($users as $user) {\n    echo $user-&gt;posts_count; \/\/ \u8ffd\u52a0\u306e\u30af\u30a8\u30ea\u306f\u767a\u751f\u3057\u306a\u3044\n}\n\n\/\/ \u8907\u6570\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u52b9\u7387\u7684\u306b\u30ed\u30fc\u30c9\n$users = User::with(['posts' =&gt; function($query) {\n    $query-&gt;select('id', 'user_id', 'title', 'created_at')  \/\/ \u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u3092\u9078\u629e\n          -&gt;where('status', 'published')\n          -&gt;latest()\n          -&gt;take(5);\n}])\n-&gt;withCount('posts')\n-&gt;get();<\/pre>\n\n\n\n<p>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6bd4\u8f03\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6e2c\u5b9a\u7528\u306e\u30b3\u30fc\u30c9\n$start = microtime(true);\n\n\/\/ \u6e2c\u5b9a\u3057\u305f\u3044\u30b3\u30fc\u30c9\n$users = User::with('posts')-&gt;get();\n\n$end = microtime(true);\n$executionTime = ($end - $start) * 1000; \/\/ \u30df\u30ea\u79d2\u5358\u4f4d\n\nLog::info(\"\u5b9f\u884c\u6642\u9593: {$executionTime}ms\");<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-19\">\u30af\u30a8\u30ea\u306e\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u9078\u629e\u7684\u30ab\u30e9\u30e0\u30ed\u30fc\u30c9<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u3092\u53d6\u5f97\n$posts = User::find(1)-&gt;posts()\n    -&gt;select(['id', 'user_id', 'title', 'created_at'])\n    -&gt;get();\n\n\/\/ \u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3059\u308b\u5834\u5408\n$posts = Post::select('posts.*', 'users.name as author_name')\n    -&gt;join('users', 'posts.user_id', '=', 'users.id')\n    -&gt;where('posts.status', 'published')\n    -&gt;get();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30c1\u30e3\u30f3\u30af\u51e6\u7406\u306b\u3088\u308b\u5927\u91cf\u30c7\u30fc\u30bf\u306e\u52b9\u7387\u7684\u306a\u51e6\u7406<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30e1\u30e2\u30ea\u52b9\u7387\u306e\u826f\u3044\u51e6\u7406\nUser::chunk(100, function ($users) {\n    foreach ($users as $user) {\n        $user-&gt;posts()-&gt;chunk(50, function ($posts) {\n            \/\/ \u6295\u7a3f\u306e\u51e6\u7406\n        });\n    }\n});\n\n\/\/ LazyCollection\u3092\u4f7f\u7528\u3057\u305f\u52b9\u7387\u7684\u306a\u51e6\u7406\nUser::lazy()-&gt;each(function ($user) {\n    $user-&gt;posts()-&gt;lazy()-&gt;each(function ($post) {\n        \/\/ \u6295\u7a3f\u306e\u51e6\u7406\n    });\n});<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-20\">N+1\u554f\u984c\u306e\u56de\u907f\u65b9\u6cd5<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u554f\u984c\u306e\u691c\u51fa<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u3092\u6709\u52b9\u5316\u3057\u3066\u554f\u984c\u3092\u691c\u51fa\nDB::enableQueryLog();\n$users = User::all();\nforeach ($users as $user) {\n    $user-&gt;posts;\n}\n$queries = DB::getQueryLog();\ndump($queries); \/\/ \u5b9f\u884c\u3055\u308c\u305f\u30af\u30a8\u30ea\u3092\u78ba\u8a8d<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u52b9\u7387\u7684\u306a\u89e3\u6c7a\u65b9\u6cd5<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u57fa\u672c\u7684\u306aEager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\n$users = User::with('posts')-&gt;get();\n\n\/\/ \u30cd\u30b9\u30c8\u3055\u308c\u305f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306eEager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\n$users = User::with('posts.comments.author')-&gt;get();\n\n\/\/ \u6761\u4ef6\u4ed8\u304dEager\u30ed\u30fc\u30c7\u30a3\u30f3\u30b0\n$users = User::with(['posts' =&gt; function($query) {\n    $query-&gt;where('status', 'published')\n          -&gt;whereYear('created_at', now()-&gt;year);\n}])-&gt;get();\n\n\/\/ \u5fc5\u8981\u306a\u5834\u5408\u306e\u307f\u30ed\u30fc\u30c9\n$users = User::when($request-&gt;includePosts, function($query) {\n    $query-&gt;with('posts');\n})-&gt;get();<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30ab\u30a6\u30f3\u30c8\u306e\u6700\u9069\u5316<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u6295\u7a3f\u6570\u306e\u30ab\u30a6\u30f3\u30c8\n$users = User::withCount('posts')-&gt;get();\n\n\/\/ \u6761\u4ef6\u4ed8\u304d\u30ab\u30a6\u30f3\u30c8\n$users = User::withCount([\n    'posts',\n    'posts as published_posts_count' =&gt; function($query) {\n        $query-&gt;where('status', 'published');\n    }\n])-&gt;get();<\/pre>\n\n\n\n<p>\u5b9f\u88c5\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u9069\u5207\u306a\u8a2d\u5b9a<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u5b9a\nSchema::create('posts', function (Blueprint $table) {\n    $table-&gt;id();\n    $table-&gt;foreignId('user_id')-&gt;constrained()-&gt;index();\n    $table-&gt;string('title');\n    $table-&gt;enum('status', ['draft', 'published'])-&gt;index();\n    $table-&gt;timestamp('published_at')-&gt;nullable()-&gt;index();\n    $table-&gt;timestamps();\n\n    \/\/ \u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\n    $table-&gt;index(['status', 'published_at']);\n});<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u6d3b\u7528<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">use Cache;\n\n\/\/ \u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u53d6\u5f97\n$posts = Cache::remember('user.posts.' . $userId, 3600, function() use ($userId) {\n    return User::find($userId)-&gt;posts()\n        -&gt;published()\n        -&gt;latest()\n        -&gt;get();\n});\n\n\/\/ \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u5358\u4f4d\u3067\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\npublic function getCachedPostsAttribute()\n{\n    return Cache::remember(\n        'user.' . $this-&gt;id . '.posts',\n        3600,\n        fn() =&gt; $this-&gt;posts()-&gt;get()\n    );\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af\u3092\u9069\u5207\u306b\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5927\u5e45\u306b\u6539\u5584\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u904e\u5ea6\u306a\u6700\u9069\u5316\u306f\u907f\u3051\u3001\u5b9f\u969b\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8a08\u6e2c\u306b\u57fa\u3065\u3044\u3066\u5fc5\u8981\u306a\u5bfe\u7b56\u3092\u8b1b\u3058\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-21\">\u3088\u304f\u3042\u308b\u30c8\u30e9\u30d6\u30eb\u3068\u89e3\u6c7a\u65b9\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-22\">\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u304c\u6b63\u3057\u304f\u52d5\u4f5c\u3057\u306a\u3044\u5834\u5408\u306e\u5bfe\u51e6\u6cd5<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u5916\u90e8\u30ad\u30fc\u306e\u4e0d\u4e00\u81f4<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\nclass User extends Model\n{\n    public function posts()\n    {\n        return $this-&gt;hasMany(Post::class); \/\/ \u30c7\u30d5\u30a9\u30eb\u30c8\u3067user_id\u3092\u63a2\u3059\n    }\n}\n\n\/\/ \u89e3\u6c7a\u7b56\uff1a\u30ab\u30b9\u30bf\u30e0\u5916\u90e8\u30ad\u30fc\u306e\u6307\u5b9a\nclass User extends Model\n{\n    public function posts()\n    {\n        return $this-&gt;hasMany(Post::class, 'author_id', 'id');\n    }\n}\n\n\/\/ \u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u4fee\u6b63\nSchema::create('posts', function (Blueprint $table) {\n    $table-&gt;id();\n    $table-&gt;foreignId('author_id')  \/\/ user_id\u3067\u306f\u306a\u304fauthor_id\u3092\u4f7f\u7528\n          -&gt;constrained('users')     \/\/ \u53c2\u7167\u30c6\u30fc\u30d6\u30eb\u3092\u660e\u793a\u7684\u306b\u6307\u5b9a\n          -&gt;onDelete('cascade');\n    $table-&gt;string('title');\n    $table-&gt;timestamps();\n});<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30e2\u30c7\u30eb\u306e\u540d\u524d\u7a7a\u9593\u306e\u554f\u984c<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\nuse App\\Models\\Post;\n\nclass User extends Model\n{\n    public function posts()\n    {\n        return $this-&gt;hasMany(Post::class); \/\/ Post\u30af\u30e9\u30b9\u304c\u898b\u3064\u304b\u3089\u306a\u3044\n    }\n}\n\n\/\/ \u89e3\u6c7a\u7b56\uff1a\u5b8c\u5168\u4fee\u98fe\u540d\u524d\u7a7a\u9593\u306e\u4f7f\u7528\nclass User extends Model\n{\n    public function posts()\n    {\n        return $this-&gt;hasMany(\\App\\Models\\Post::class);\n        \/\/ \u307e\u305f\u306f\n        \/\/ use App\\Models\\Post; \u3092\u30d5\u30a1\u30a4\u30eb\u5148\u982d\u3067\u5ba3\u8a00\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-23\">\u30c7\u30fc\u30bf\u6574\u5408\u6027\u306e\u78ba\u4fdd\u65b9\u6cd5<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30ab\u30b9\u30b1\u30fc\u30c9\u524a\u9664\u306e\u9069\u5207\u306a\u8a2d\u5b9a<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u8a2d\u5b9a\nSchema::create('posts', function (Blueprint $table) {\n    $table-&gt;id();\n    $table-&gt;foreignId('user_id')\n          -&gt;constrained()\n          -&gt;onDelete('cascade')    \/\/ \u30e6\u30fc\u30b6\u30fc\u524a\u9664\u6642\u306b\u6295\u7a3f\u3082\u524a\u9664\n          -&gt;onUpdate('cascade');   \/\/ \u30e6\u30fc\u30b6\u30fcID\u5909\u66f4\u6642\u306b\u8ffd\u5f93\n});\n\n\/\/ \u30e2\u30c7\u30eb\u3067\u306e\u8a2d\u5b9a\nclass User extends Model\n{\n    protected static function boot()\n    {\n        parent::boot();\n\n        \/\/ \u524a\u9664\u524d\u306b\u95a2\u9023\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\n        static::deleting(function($user) {\n            \/\/ \u91cd\u8981\u306a\u30c7\u30fc\u30bf\u304c\u3042\u308b\u5834\u5408\u306f\u524a\u9664\u3092\u4e2d\u6b62\n            if ($user-&gt;posts()-&gt;where('status', 'important')-&gt;exists()) {\n                return false;\n            }\n        });\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30c7\u30fc\u30bf\u66f4\u65b0\u6642\u306e\u6574\u5408\u6027\u30c1\u30a7\u30c3\u30af<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class PostController extends Controller\n{\n    public function update(Request $request, Post $post)\n    {\n        \/\/ \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u6574\u5408\u6027\u3092\u4fdd\u8a3c\n        DB::transaction(function() use ($request, $post) {\n            \/\/ \u6295\u7a3f\u3092\u66f4\u65b0\n            $post-&gt;update($request-&gt;validated());\n\n            \/\/ \u95a2\u9023\u30c7\u30fc\u30bf\u3082\u540c\u6642\u306b\u66f4\u65b0\n            if ($request-&gt;has('tags')) {\n                $post-&gt;tags()-&gt;sync($request-&gt;tags);\n            }\n\n            \/\/ \u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u66f4\u65b0\n            Cache::forget('user.' . $post-&gt;user_id . '.posts');\n        });\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-24\">\u5faa\u74b0\u53c2\u7167\u306e\u9632\u6b62\u7b56<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u76f4\u63a5\u7684\u306a\u5faa\u74b0\u53c2\u7167\u306e\u9632\u6b62<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\uff08\u5faa\u74b0\u53c2\u7167\uff09\nclass Department extends Model\n{\n    public function employees()\n    {\n        return $this-&gt;hasMany(Employee::class);\n    }\n}\n\nclass Employee extends Model\n{\n    public function department()\n    {\n        return $this-&gt;belongsTo(Department::class);\n    }\n\n    public function subordinates()\n    {\n        return $this-&gt;hasMany(Employee::class, 'manager_id');\n    }\n\n    public function manager()\n    {\n        return $this-&gt;belongsTo(Employee::class, 'manager_id');\n    }\n}\n\n\/\/ \u89e3\u6c7a\u7b56\uff1a\u6761\u4ef6\u4ed8\u304d\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u4f7f\u7528\nclass Employee extends Model\n{\n    public function subordinates()\n    {\n        return $this-&gt;hasMany(Employee::class, 'manager_id')\n                    -&gt;whereNull('end_date');  \/\/ \u6709\u52b9\u306a\u95a2\u4fc2\u306e\u307f\u3092\u53d6\u5f97\n    }\n\n    \/\/ \u518d\u5e30\u7684\u306a\u95a2\u4fc2\u3092\u5236\u9650\n    public function allSubordinates()\n    {\n        return $this-&gt;hasMany(Employee::class, 'manager_id')\n                    -&gt;with('subordinates')\n                    -&gt;whereNull('end_date')\n                    -&gt;limit(100);  \/\/ \u6df1\u3055\u5236\u9650\u3092\u8a2d\u5b9a\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u7121\u9650\u30eb\u30fc\u30d7\u306e\u9632\u6b62<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u554f\u984c\u304c\u8d77\u3053\u308a\u3084\u3059\u3044\u30b3\u30fc\u30c9\npublic function getAllSubordinates()\n{\n    return $this-&gt;subordinates-&gt;map(function($subordinate) {\n        return collect([$subordinate])\n            -&gt;merge($subordinate-&gt;getAllSubordinates());\n    })-&gt;flatten();\n}\n\n\/\/ \u89e3\u6c7a\u7b56\uff1a\u6df1\u3055\u5236\u9650\u306e\u5c0e\u5165\npublic function getAllSubordinates($depth = 5)\n{\n    if ($depth &lt;= 0) {\n        return collect();\n    }\n\n    return $this-&gt;subordinates-&gt;map(function($subordinate) use ($depth) {\n        return collect([$subordinate])\n            -&gt;merge($subordinate-&gt;getAllSubordinates($depth - 1));\n    })-&gt;flatten();\n}\n\n\/\/ \u3088\u308a\u52b9\u7387\u7684\u306a\u89e3\u6c7a\u7b56\uff1a\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u3092\u4f7f\u7528\npublic function getAllSubordinatesQuery()\n{\n    return Employee::where(function($query) {\n        $query-&gt;where('path', 'like', $this-&gt;path . '%')\n              -&gt;where('id', '!=', $this-&gt;id);\n    });\n}<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30c7\u30d0\u30c3\u30b0\u3068\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u306e\u6709\u52b9\u5316\nDB::enableQueryLog();\n\ntry {\n    \/\/ \u554f\u984c\u306e\u3042\u308b\u51e6\u7406\n    $result = $user-&gt;posts()-&gt;with('comments.author')-&gt;get();\n} catch (\\Exception $e) {\n    \/\/ \u30af\u30a8\u30ea\u30ed\u30b0\u306e\u78ba\u8a8d\n    logger()-&gt;error('Query Log:', DB::getQueryLog());\n    logger()-&gt;error('Error:', [\n        'message' =&gt; $e-&gt;getMessage(),\n        'trace' =&gt; $e-&gt;getTraceAsString()\n    ]);\n    throw $e;\n}\n\n\/\/ \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8a08\u6e2c\n$start = microtime(true);\n$result = $user-&gt;posts()-&gt;get();\n$end = microtime(true);\nlogger()-&gt;info('Execution time: ' . ($end - $start) * 1000 . 'ms');<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u554f\u984c\u306b\u5bfe\u3059\u308b\u89e3\u6c7a\u7b56\u3092\u5b9f\u88c5\u3059\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u5805\u7262\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u69cb\u7bc9\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u307e\u305f\u3001\u5b9a\u671f\u7684\u306a\u30b3\u30fc\u30c9\u30ec\u30d3\u30e5\u30fc\u3068\u30c6\u30b9\u30c8\u306e\u5b9f\u65bd\u306b\u3088\u308a\u3001\u554f\u984c\u3092\u65e9\u671f\u306b\u767a\u898b\u3057\u5bfe\u51e6\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-25\">\u95a2\u9023\u3059\u308b\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30bf\u30a4\u30d7\u3068\u306e\u4f7f\u3044\u5206\u3051<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-26\">belongsTo\u3068hasMany\u306e\u9055\u3044<\/h3>\n\n\n\n<p>belongsTo\u3068hasMany\u306f\u3001\u540c\u3058\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u4e21\u7aef\u3092\u8868\u73fe\u3059\u308b\u76f8\u88dc\u7684\u306a\u95a2\u4fc2\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ hasMany\u5074\uff08\u89aa\u30e2\u30c7\u30eb\uff09\nclass User extends Model\n{\n    \/\/ 1\u4eba\u306e\u30e6\u30fc\u30b6\u30fc\u304c\u591a\u6570\u306e\u6295\u7a3f\u3092\u6301\u3064\n    public function posts()\n    {\n        return $this-&gt;hasMany(Post::class);\n    }\n}\n\n\/\/ belongsTo\u5074\uff08\u5b50\u30e2\u30c7\u30eb\uff09\nclass Post extends Model\n{\n    \/\/ 1\u3064\u306e\u6295\u7a3f\u306f1\u4eba\u306e\u30e6\u30fc\u30b6\u30fc\u306b\u5c5e\u3059\u308b\n    public function user()\n    {\n        return $this-&gt;belongsTo(User::class);\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\u306e\u9055\u3044\n\/\/ hasMany\u306e\u5834\u5408\uff081\u5bfe\u591a\u306e\u300c1\u300d\u5074\uff09\n$user = User::find(1);\n$posts = $user-&gt;posts;  \/\/ \u305d\u306e\u30e6\u30fc\u30b6\u30fc\u306e\u5168\u6295\u7a3f\u3092\u53d6\u5f97\n\n\/\/ belongsTo\u306e\u5834\u5408\uff081\u5bfe\u591a\u306e\u300c\u591a\u300d\u5074\uff09\n$post = Post::find(1);\n$user = $post-&gt;user;    \/\/ \u305d\u306e\u6295\u7a3f\u306e\u4f5c\u6210\u8005\u3092\u53d6\u5f97<\/pre>\n\n\n\n<p>\u4e3b\u306a\u9055\u3044\u306e\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n<div id=\"id-600539fd-396a-4fe7-885c-acf5bfba3c55\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u7279\u5fb4<\/th><th>hasMany<\/th><th>belongsTo<\/th><\/tr><\/thead><tbody><tr><td>\u95a2\u4fc2\u6027<\/td><td>\u89aa\u304b\u3089\u5b50<\/td><td>\u5b50\u304b\u3089\u89aa<\/td><\/tr><tr><td>\u5916\u90e8\u30ad\u30fc<\/td><td>\u76f8\u624b\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5b58\u5728<\/td><td>\u81ea\u5206\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5b58\u5728<\/td><\/tr><tr><td>\u53d6\u5f97\u4ef6\u6570<\/td><td>\u8907\u6570\u30ec\u30b3\u30fc\u30c9<\/td><td>\u5358\u4e00\u30ec\u30b3\u30fc\u30c9<\/td><\/tr><tr><td>\u3088\u304f\u3042\u308b\u7528\u9014<\/td><td>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u64cd\u4f5c<\/td><td>\u89aa\u60c5\u5831\u306e\u53c2\u7167<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-27\">hasManyThrough\u306e\u6d3b\u7528\u30b7\u30fc\u30f3<\/h3>\n\n\n\n<p>hasManyThrough\u306f\u3001\u4e2d\u9593\u30c6\u30fc\u30d6\u30eb\u3092\u4ecb\u3057\u305f\u9593\u63a5\u7684\u306a1\u5bfe\u591a\u306e\u95a2\u4fc2\u3092\u8868\u73fe\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u56fd\u3001\u30e6\u30fc\u30b6\u30fc\u3001\u6295\u7a3f\u306e\u95a2\u4fc2\nclass Country extends Model\n{\n    \/\/ \u56fd\u304b\u3089\u76f4\u63a5\u6295\u7a3f\u3092\u53d6\u5f97\uff08\u30e6\u30fc\u30b6\u30fc\u3092\u4ecb\u3057\u3066\uff09\n    public function posts()\n    {\n        return $this-&gt;hasManyThrough(\n            Post::class,      \/\/ \u6700\u7d42\u7684\u306b\u53d6\u5f97\u3057\u305f\u3044\u30e2\u30c7\u30eb\n            User::class,      \/\/ \u4e2d\u9593\u30e2\u30c7\u30eb\n            'country_id',     \/\/ users\u30c6\u30fc\u30d6\u30eb\u306e\u5916\u90e8\u30ad\u30fc\n            'user_id',        \/\/ posts\u30c6\u30fc\u30d6\u30eb\u306e\u5916\u90e8\u30ad\u30fc\n            'id',             \/\/ countries\u30c6\u30fc\u30d6\u30eb\u306e\u30ed\u30fc\u30ab\u30eb\u30ad\u30fc\n            'id'             \/\/ users\u30c6\u30fc\u30d6\u30eb\u306e\u30ed\u30fc\u30ab\u30eb\u30ad\u30fc\n        );\n    }\n}\n\n\/\/ \u5b9f\u969b\u306e\u4f7f\u7528\u4f8b\n$country = Country::find(1);\n$countryPosts = $country-&gt;posts;  \/\/ \u305d\u306e\u56fd\u306e\u30e6\u30fc\u30b6\u30fc\u306b\u3088\u308b\u5168\u6295\u7a3f\u3092\u53d6\u5f97\n\n\/\/ \u3088\u308a\u8907\u96d1\u306a\u4f8b\uff1a\u90e8\u9580\u3001\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u3001\u5f93\u696d\u54e1\u306e\u95a2\u4fc2\nclass Department extends Model\n{\n    \/\/ \u90e8\u9580\u304b\u3089\u76f4\u63a5\u4e00\u822c\u5f93\u696d\u54e1\u3092\u53d6\u5f97\uff08\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u3092\u4ecb\u3057\u3066\uff09\n    public function staffMembers()\n    {\n        return $this-&gt;hasManyThrough(\n            Employee::class,\n            Manager::class,\n            'department_id',  \/\/ managers\u30c6\u30fc\u30d6\u30eb\u306e\u5916\u90e8\u30ad\u30fc\n            'manager_id',     \/\/ employees\u30c6\u30fc\u30d6\u30eb\u306e\u5916\u90e8\u30ad\u30fc\n            'id',\n            'id'\n        );\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-28\">\u9069\u5207\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30bf\u30a4\u30d7\u306e\u9078\u629e\u65b9\u6cd5<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30c7\u30fc\u30bf\u306e\u95a2\u4fc2\u6027\u306b\u57fa\u3065\u304f\u9078\u629e<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ 1\u5bfe1\u306e\u95a2\u4fc2\nclass User extends Model\n{\n    \/\/ \u30e6\u30fc\u30b6\u30fc\u30d7\u30ed\u30d5\u30a3\u30fc\u30eb\uff081\u3064\u3060\u3051\uff09\n    public function profile()\n    {\n        return $this-&gt;hasOne(Profile::class);\n    }\n}\n\n\/\/ 1\u5bfe\u591a\u306e\u95a2\u4fc2\nclass User extends Model\n{\n    \/\/ \u30e6\u30fc\u30b6\u30fc\u306e\u6295\u7a3f\uff08\u8907\u6570\uff09\n    public function posts()\n    {\n        return $this-&gt;hasMany(Post::class);\n    }\n}\n\n\/\/ \u591a\u5bfe\u591a\u306e\u95a2\u4fc2\nclass User extends Model\n{\n    \/\/ \u30e6\u30fc\u30b6\u30fc\u306e\u5f79\u5272\uff08\u8907\u6570\u306e\u5f79\u5272\u3001\u8907\u6570\u306e\u30e6\u30fc\u30b6\u30fc\uff09\n    public function roles()\n    {\n        return $this-&gt;belongsToMany(Role::class);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u9069\u5207\u306a\u9078\u629e\u306e\u305f\u3081\u306e\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/strong><\/li>\n<\/ol>\n\n\n\n<p>\u4ee5\u4e0b\u306e\u8cea\u554f\u306b\u7b54\u3048\u308b\u3053\u3068\u3067\u3001\u9069\u5207\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30bf\u30a4\u30d7\u3092\u9078\u629e\u3067\u304d\u307e\u3059\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30c7\u30fc\u30bf\u306e\u95a2\u4fc2\u306f\u4e00\u65b9\u5411\u304b\u53cc\u65b9\u5411\u304b\uff1f<\/li>\n\n\n\n<li>\u4e00\u3064\u306e\u30ec\u30b3\u30fc\u30c9\u306b\u5bfe\u3057\u3066\u95a2\u9023\u30ec\u30b3\u30fc\u30c9\u306f\u8907\u6570\u5b58\u5728\u3059\u308b\u304b\uff1f<\/li>\n\n\n\n<li>\u4e2d\u9593\u30c6\u30fc\u30d6\u30eb\u306f\u5fc5\u8981\u304b\uff1f<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3078\u306e\u5f71\u97ff\u306f\uff1f<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u5b9f\u88c5\u4f8b\uff1a\u30d6\u30ed\u30b0\u30b7\u30b9\u30c6\u30e0\u3067\u306e\u5404\u7a2e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\nclass Blog extends Model\n{\n    \/\/ 1\u5bfe1\uff1a\u30d6\u30ed\u30b0\u306e\u8a2d\u5b9a\n    public function settings()\n    {\n        return $this-&gt;hasOne(BlogSettings::class);\n    }\n\n    \/\/ 1\u5bfe\u591a\uff1a\u30d6\u30ed\u30b0\u306e\u6295\u7a3f\n    public function posts()\n    {\n        return $this-&gt;hasMany(Post::class);\n    }\n\n    \/\/ \u591a\u5bfe\u591a\uff1a\u30d6\u30ed\u30b0\u306e\u30ab\u30c6\u30b4\u30ea\u30fc\n    public function categories()\n    {\n        return $this-&gt;belongsToMany(Category::class);\n    }\n\n    \/\/ hasManyThrough\uff1a\u30d6\u30ed\u30b0\u304b\u3089\u76f4\u63a5\u30b3\u30e1\u30f3\u30c8\u3092\u53d6\u5f97\n    public function comments()\n    {\n        return $this-&gt;hasManyThrough(Comment::class, Post::class);\n    }\n}<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u8003\u616e\u3057\u305f\u9078\u629e<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u52b9\u7387\u7684\u306a\u30af\u30a8\u30ea\u5b9f\u884c\u306e\u305f\u3081\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u8a2d\u8a08\nclass Order extends Model\n{\n    \/\/ 1\u5bfe\u591a\uff1a\u57fa\u672c\u7684\u306a\u95a2\u4fc2\n    public function items()\n    {\n        return $this-&gt;hasMany(OrderItem::class);\n    }\n\n    \/\/ has-many-through\uff1a\u6700\u9069\u5316\u3055\u308c\u305f\u9593\u63a5\u95a2\u4fc2\n    public function products()\n    {\n        return $this-&gt;hasManyThrough(\n            Product::class,\n            OrderItem::class,\n            'order_id',    \/\/ order_items.order_id\n            'id',          \/\/ products.id\n            'id',          \/\/ orders.id\n            'product_id'   \/\/ order_items.product_id\n        )-&gt;select('products.*')  \/\/ \u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u9078\u629e\n         -&gt;distinct();           \/\/ \u91cd\u8907\u3092\u9664\u5916\n    }\n}<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30bf\u30a4\u30d7\u3092\u9069\u5207\u306b\u4f7f\u3044\u5206\u3051\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u4fdd\u5b88\u6027\u304c\u9ad8\u304f\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u826f\u3044\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u69cb\u7bc9\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u91cd\u8981\u306a\u306e\u306f\u3001\u30c7\u30fc\u30bf\u306e\u95a2\u4fc2\u6027\u3092\u6b63\u78ba\u306b\u7406\u89e3\u3057\u3001\u305d\u308c\u306b\u57fa\u3065\u3044\u3066\u6700\u9069\u306a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30bf\u30a4\u30d7\u3092\u9078\u629e\u3059\u308b\u3053\u3068\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Warning: Undefined array key &#8220;is_admin&#8221; in \/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/ &#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-2611","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-php","7":"nothumb"},"_links":{"self":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/2611","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2611"}],"version-history":[{"count":2,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/2611\/revisions"}],"predecessor-version":[{"id":2613,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/2611\/revisions\/2613"}],"wp:attachment":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}