Eloquent ORM 查询数据的关联扩展

WBOY
發布: 2016-06-06 20:36:40
原創
895 人瀏覽過

     user [{
         id: 1,
         name: "jack",
         age: "22",
         city_id: 1,
         job_id: 1
     },
     {
         id: 2,
         name: "yoyo",
         age: "22",
         city_id: 2,
         job_id: 2
     }];
     
     city [{
         id: 1,
         name: "beijin"
     },
     {  
        id: 2,
        name: "shanghai"
     }]
     
登入後複製
登入後複製

单独查询表的结果是这样的,我想实现类似下面的扩展结果要怎么操作,看了api文档还是不太明白

    user [{
         id: 1,
         name: "jack",
         age: "22",
         city: {id: 1, name: "beijin"},
         job_id: {id:1, name: "dev"}
     },
     {
         id: 2,
         name: "yoyo",
         age: "22",
         city: {id: 2, name: "shanghai"},
         job: {id: 2, name: "art"}
     }];
登入後複製
登入後複製

回复内容:

     user [{
         id: 1,
         name: "jack",
         age: "22",
         city_id: 1,
         job_id: 1
     },
     {
         id: 2,
         name: "yoyo",
         age: "22",
         city_id: 2,
         job_id: 2
     }];
     
     city [{
         id: 1,
         name: "beijin"
     },
     {  
        id: 2,
        name: "shanghai"
     }]
     
登入後複製
登入後複製

单独查询表的结果是这样的,我想实现类似下面的扩展结果要怎么操作,看了api文档还是不太明白

    user [{
         id: 1,
         name: "jack",
         age: "22",
         city: {id: 1, name: "beijin"},
         job_id: {id:1, name: "dev"}
     },
     {
         id: 2,
         name: "yoyo",
         age: "22",
         city: {id: 2, name: "shanghai"},
         job: {id: 2, name: "art"}
     }];
登入後複製
登入後複製
相關標籤:
來源:php.cn
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板