Codeigniter join() not working

Question

我正在尝试使用codeigniter框架运行查询。我希望避免使用WHERE子句，而是将条件作为ON子句的一部分包含在查询的JOIN语句中。由于JOIN语句是在WHERE子句之前执行的，因此这将更加高效。这是我的代码：

    $this->db->select('SQL_CALC_FOUND_ROWS
        projects.id, projects.project_name, projects.date_modified, 
        projects.last_modifier, projects.status, project_users.permission', false)->
            from('projects');
        $this->db->join('project_users', 'project_users.id = projects.id AND 
            project_users.user_id = ' . $this->user_id);
    if ($orderby !== false) {
        $this->db->order_by($orderby, $direction);
    }
    if ($limit !== null) {
        $this->db->limit($limit, $offset);
    }
    $query = $this->db->get();

当我尝试加载页面时，我收到一个SQL错误。似乎代码点火器不包括AND之后的条件：

SELECT SQL_CALC_FOUND_ROWS projects.id, projects.project_name, projects.date_modified, projects.last_modifier, projects.status, project_users.permission FROM (`projects`) JOIN `project_users` ON `project_users`.`id` = `projects`.`id` AND ORDER BY `project_name` ASC LIMIT 5, 0

Answer 1

join('project_users', 'project_users.id = projects.id AND project_users.user_id = ' . $this->user_id);

应该是

$this->db->join('project_users', 'project_users.id = projects.id AND 
        project_users.user_id = ' . $this->user_id);