alias('rbook') ->join('book','rbook.book_id = book.id') ->field('rbook.*') ->field('book.name,book.image,book.first_chapter_id,book.first_chapter_name') ->where('rbook.status', 'eq', 'normal') -> select(); return $data; } }