用这个
function getTask($id, $is_master_admin){$this->db->select('task.*, workspace.title as workspacetitle, GROUP_CONCAt( user.title ) AS usertitle,task.assigneduserid,user.id',FALSE);$this->db->join(WORKSPACE , WORKSPACE . '.id = ' . TASK . '.workspaceid', 'inner');$this->db->join(USER,("FIND_IN_SET(USER .id , TASK.assigneduserid)"), 'inner');$this->db->from(TASK);$this->db->group_by("task.id");if (!$is_master_admin){$this->db->where ("FIND_IN_SET($id, task.assigneduserid)");}$this->db->where(TASK . '.tasktypeid', '1');$query = $this->db->get();if ($query->num_rows() > 0) {return $query->result();} else {return false;}}
