它可以自己加入单个表吗？

Question

this is the model function i am trying join the single database table it self the , parent::get method fetch the data from the table !

public function get_with_parents($id=NULL,$single=FALSE){
$this->db->select('pages.*','p.slug as parent_slug','p.title as parent_title');
$this->db->join('pages as p','pages.parent_id=p.id','left');
return parent::get($id,$single);
}

this is the controller!!

$this->data ['pages'] = $this->Page_model->get_with_parents();

Answer 1

Assuming your single tables is called pages, this should work -

$this->db->select('p1.title as ptitle','p.slug as parent_slug','p.title as parent_title');
$this->db->from('pages AS p1');
$this->db->join('pages AS p','p1.parent_id=p.id','left');