# thinkphp 一對多 多對一的源碼實例 一對一關聯: has\_one 以及相對的belongs\_to 一對多關聯：has\_many 以及相對的belongs\_to 多對多關聯: belongs\_to\_many： 一對多:hasmany(關聯模型名，外鍵名，主鍵名【模型別名定義】) 一對一： hasone(關聯模型名，外鍵名，關聯主鍵名，【模型別名】，json類型) 一對多 ： user表和article表 user表字段 username 和password article表字段 content和user\_id ``` <pre class="calibre13">``` user 模型 <span class="token"><</span><span class="token">?</span>php namespace app\\api\\model<span class="token1">;</span> use think\\Model<span class="token1">;</span> <span class="token2">class</span> <span class="token3">User</span> <span class="token2">extends</span> <span class="token3">Model</span> <span class="token1">{</span> <span class="token3">publicfunction guanlian</span><span class="token1">(</span><span class="token1">)</span> <span class="token1">{</span> <span class="token2">return</span>$<span class="token2">this</span>\<span class="token">-</span><span class="token">></span><span class="token3">hasMany</span><span class="token1">(</span><span class="token4">'app\\api\\model\\okl\\Article'</span><span class="token1">,</span> <span class="token4">'user\_id'</span><span class="token1">,</span> <span class="token4">'id'</span><span class="token1">)</span><span class="token1">;</span> <span class="token1">}</span> <span class="token1">}</span> ``` ``` ``` <pre class="calibre13">``` article模型 <span class="token"><</span><span class="token">?</span>php namespace app\\api\\model\\okl<span class="token1">;</span> use think\\Model<span class="token1">;</span> <span class="token2">class</span> <span class="token3">Article</span> <span class="token2">extends</span> <span class="token3">Model</span> <span class="token1">{</span> <span class="token3">publicfunction Article</span><span class="token1">(</span><span class="token1">)</span> <span class="token1">{</span> <span class="token1">}</span> <span class="token1">}</span> ``` ``` ``` <pre class="calibre13">``` 控制器 namespace app\\api\\controller<span class="token1">;</span> use app\\api\\model\\User<span class="token1">;</span> use think\\Controller<span class="token1">;</span> <span class="token2">class</span> <span class="token3">Onetomany</span> <span class="token2">extends</span> <span class="token3">Controller</span> <span class="token1">{</span> <span class="token3">publicfunction ceshi</span><span class="token1">(</span><span class="token1">)</span> <span class="token1">{</span> $user \<span class="token">=</span> User<span class="token1">:</span><span class="token1">:</span><span class="token2">get</span><span class="token1">(</span><span class="token5">2</span><span class="token1">)</span><span class="token1">;</span> <span class="token2">return</span> $user\<span class="token">-</span><span class="token">></span>guanlian<span class="token1">;</span> <span class="token1">}</span> <span class="token1">}</span> ``` ``` 返回數據： ``` <pre class="calibre13">``` <span class="token1">[</span> <span class="token1">{</span> <span class="token4">"id"</span><span class="token1">:</span> <span class="token5">3</span><span class="token1">,</span> <span class="token4">"content"</span><span class="token1">:</span> <span class="token4">"評論3"</span><span class="token1">,</span> <span class="token4">"user_id"</span><span class="token1">:</span> <span class="token5">2</span> <span class="token1">}</span><span class="token1">,</span> <span class="token1">{</span> <span class="token4">"id"</span><span class="token1">:</span> <span class="token5">5</span><span class="token1">,</span> <span class="token4">"content"</span><span class="token1">:</span> <span class="token4">"評論5"</span><span class="token1">,</span> <span class="token4">"user_id"</span><span class="token1">:</span> <span class="token5">2</span> <span class="token1">}</span> <span class="token1">]</span> ``` ``` 接下來用belongto ``` <pre class="calibre13">``` <span class="token"><</span><span class="token">?</span>php namespace app\\api\\model<span class="token1">;</span> use think\\Model<span class="token1">;</span> <span class="token2">class</span> <span class="token3">User</span> <span class="token2">extends</span> <span class="token3">Model</span> <span class="token1">{</span> <span class="token1">}</span> ``` ``` ``` <pre class="calibre13">``` <span class="token"><</span><span class="token">?</span>php namespace app\\api\\model\\okl<span class="token1">;</span> use think\\Model<span class="token1">;</span> <span class="token2">class</span> <span class="token3">Article</span> <span class="token2">extends</span> <span class="token3">Model</span> <span class="token1">{</span> <span class="token3">publicfunction guanlian</span><span class="token1">(</span><span class="token1">)</span> <span class="token1">{</span> <span class="token2">return</span>$<span class="token2">this</span>\<span class="token">-</span><span class="token">></span><span class="token3">belongsTo</span><span class="token1">(</span><span class="token4">'app\\api\\model\\User'</span><span class="token1">,</span> <span class="token4">'user\_id'</span><span class="token1">,</span> <span class="token4">'id'</span><span class="token1">)</span><span class="token1">;</span> <span class="token1">}</span> <span class="token1">}</span> ``` ``` ``` <pre class="calibre13">``` <span class="token"><</span><span class="token">?</span>php namespace app\\api\\controller<span class="token1">;</span> use app\\api\\model\\okl\\Article<span class="token1">;</span> use think\\Controller<span class="token1">;</span> <span class="token2">class</span> <span class="token3">Onetomany</span> <span class="token2">extends</span> <span class="token3">Controller</span> <span class="token1">{</span> <span class="token3">publicfunction ceshi</span><span class="token1">(</span><span class="token1">)</span> <span class="token1">{</span> $article \<span class="token">=</span> Article<span class="token1">:</span><span class="token1">:</span><span class="token2">get</span><span class="token1">(</span><span class="token5">3</span><span class="token1">)</span><span class="token1">;</span> <span class="token2">return</span> $article\<span class="token">-</span><span class="token">></span>guanlian<span class="token1">;</span> <span class="token1">}</span> <span class="token1">}</span> ``` ``` { "id": 2, "username": "ceshi2", "password": "mima2" } ``` <pre class="calibre14">``` <span class="token"><</span><span class="token">?</span>php namespace app\\api\\controller<span class="token1">;</span> use app\\api\\model\\User<span class="token1">;</span> use think\\Controller<span class="token1">;</span> <span class="token2">class</span> <span class="token3">Onetomany</span> <span class="token2">extends</span> <span class="token3">Controller</span> <span class="token1">{</span> <span class="token3">publicfunction ceshi</span><span class="token1">(</span><span class="token1">)</span> <span class="token1">{</span> $user \<span class="token">=</span> User<span class="token1">:</span><span class="token1">:</span><span class="token2">with</span><span class="token1">(</span><span class="token4">'guanlian'</span><span class="token1">)</span>\<span class="token">-</span><span class="token">></span><span class="token3">select</span><span class="token1">(</span><span class="token1">)</span><span class="token1">;</span> <span class="token3">foreach</span><span class="token1">(</span>$user <span class="token2">as</span> $data<span class="token1">)</span><span class="token1">{</span> <span class="token2">return</span><span class="token1">(</span>$data\<span class="token">-</span><span class="token">></span>guanlian<span class="token1">)</span><span class="token1">;</span> <span class="token1">}</span> <span class="token1">}</span> <span class="token1">}</span> ``` ```