->alias('a')
->join('dp_admin_user u','a.created_uid = u.id','LEFT')
->join('dp_admin_user us','a.updated_uid = us.id','LEFT')//这个不想要
->where($where)
->order("id desc")
->limit($start,$length)
->field('a.*,u.nickname created_uid,us.nickname update_uid')
->select();
最佳答案