$pj = M('pj as p');
$tea = M('teacher');
$data = array();
/****************************************/ $where["departmentid"] = $departmentid; $te = $tea->field('name,username as id,departmentid')->where($where)->select(); foreach ($te as $key => $value) {
$teacherid["teacherid"] = $value["id"];
$pjgl = $pj
->field('p.*,tp.name as name,tp.typename,tp.type,tp.roleid,tp.rolename')
->join('testpaper as tp on tp.id=p.testpaperid')
->where($teacherid)
->select();
if (count($pjgl)>0){
$value["children"] = $pjgl;
$data[] = $value;
}
}
$this->ajaxReturn($data);
$tea = M('teacher');
$data = array();
/****************************************/ $where["departmentid"] = $departmentid; $te = $tea->field('name,username as id,departmentid')->where($where)->select(); foreach ($te as $key => $value) {
$teacherid["teacherid"] = $value["id"];
$pjgl = $pj
->field('p.*,tp.name as name,tp.typename,tp.type,tp.roleid,tp.rolename')
->join('testpaper as tp on tp.id=p.testpaperid')
->where($teacherid)
->select();
if (count($pjgl)>0){
$value["children"] = $pjgl;
$data[] = $value;
}
}
$this->ajaxReturn($data);
既然 foreach 循环内都 join 了,那么为何不整体来个 join?