{"id":375,"title":"\u4e00\u4e2a\u7b80\u5355\u7684laravel\u5206\u8868\u8054\u5408\u67e5\u8be2","good":7,"bad":25,"hit":4759,"created_at":"2018-07-24 22:46:11","content":"<p>\u6709\u65f6\u5019\u4f1a\u9047\u5230\u6570\u636e\u91cf\u8f83\u5927\u65f6\uff0c\u4f1a\u5bf9\u6570\u636e\u8868\u8fdb\u884c\u5206\u8868\uff0c\u4f46\u662f\u67e5\u8be2\u7684\u65f6\u5019\u53c8\u9700\u8981\u5c06\u6570\u636e\u5408\u5e76\u67e5\u8be2\uff0c\u8fd9\u91cc\u8bd5\u7740\u5199\u4e86\u4e00\u4e2a\u7b80\u5355\u7684\u5206\u8868\u8054\u8868\u67e5\u8be2\uff1a<\/p><p><br\/><\/p><p>\u8fd9\u91cc\u53ea\u662f\u5b66\u4e60\u6d4b\u8bd5\uff0c\u751f\u4ea7\u73af\u5883\u8981\u6ce8\u610f\u8fd9\u4e24\u4e2a\u8868\u7684id\u4e0d\u80fd\u91cd\u590d\uff1b<\/p><p><br\/><\/p><p><img src=\"https:\/\/api.hu-rong.com\/uploads\/image\/20180724\/1532443423701081.png\" title=\"1532443423701081.png\" alt=\"image.png\"\/><\/p><pre class=\"brush:php;toolbar:false\">\/**\n&nbsp;*&nbsp;\u5206\u8868\u65f6\u7684\u8054\u8868\u67e5\u8be2\n&nbsp;*\/\npublic&nbsp;function&nbsp;index2()\n{\n&nbsp;&nbsp;&nbsp;&nbsp;$queries&nbsp;=&nbsp;collect();\n&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;($i&nbsp;=&nbsp;1;&nbsp;$i&nbsp;&lt;=&nbsp;2;&nbsp;$i++)&nbsp;{\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$queries-&gt;push(DB::table(&#39;test&#39;&nbsp;.&nbsp;$i)-&gt;select());\n&nbsp;&nbsp;&nbsp;&nbsp;}\n&nbsp;&nbsp;&nbsp;&nbsp;$unionQuery&nbsp;=&nbsp;$queries-&gt;shift();\n&nbsp;&nbsp;&nbsp;&nbsp;$queries-&gt;each(function&nbsp;($item,&nbsp;$key)&nbsp;use&nbsp;($unionQuery)&nbsp;{\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$unionQuery-&gt;unionAll($item);\n&nbsp;&nbsp;&nbsp;&nbsp;});\n&nbsp;&nbsp;&nbsp;&nbsp;dd($unionQuery-&gt;get([&#39;id&#39;,&nbsp;&#39;name&#39;])-&gt;where(&#39;id&#39;,&#39;&gt;&#39;,0)-&gt;toArray());\n}<\/pre><pre class=\"brush:php;toolbar:false\">array:2&nbsp;[\u25bc\n&nbsp;&nbsp;0&nbsp;=&gt;&nbsp;{#455&nbsp;\u25bc\n&nbsp;&nbsp;&nbsp;&nbsp;+&quot;id&quot;:&nbsp;1\n&nbsp;&nbsp;&nbsp;&nbsp;+&quot;name&quot;:&nbsp;&quot;test1&quot;&nbsp;&nbsp;}&nbsp;&nbsp;\n&nbsp;&nbsp;1&nbsp;=&gt;&nbsp;{#456&nbsp;\u25bc\n&nbsp;&nbsp;&nbsp;&nbsp;+&quot;id&quot;:&nbsp;1\n&nbsp;&nbsp;&nbsp;&nbsp;+&quot;name&quot;:&nbsp;&quot;test2&quot;&nbsp;&nbsp;}]<\/pre><p><br\/><\/p>"}