我正在使用Laravel Query Builder和我的join语句工作得很好。
User
表列:
name|email|phone|gender
School_Abouts
表列:
courses|boards|contact|location|teachers
目前我执行的select查询如下:
$school=User::join('school_abouts', 'users.id', '=', 'school_abouts.school_id')
->where('users.id',$id)
->select('users.name',
'users.email',
'users.phone',
'school_abouts.courses',
'school_abouts.boards',
'school_abouts.contact',
'school_abouts.location',
'school_abouts.teachers')
->first();
要从school_about
表中选择列,我必须多次写入表名。但是,有没有办法传递一个列数组呢?我试过了,但失败了:
->select('users.name',
'users.email',
'users.phone',
'school_abouts'.[courses,boards,location,contact,teachers],
)
https://stackoverflow.com/questions/50773387
复制相似问题