<?php

class User extends MY_Model {
    protected $relations = array(
        'books' => 'id'
    );
}

// This...
$this->db->select('users.*, books.*')->join('books', 'books.id = users.id')->get();

// ...becomes this.
$this->user->with_relation('books')->get_all();