Mysql left join查询方法

---

$books = $wpdb->get_results("SELECT book.*,book_shelf.shelf_name FROM " . $this->table_activator->booktable . " as book LEFT JOIN " . $this->table_activator->shelftable . " as book_shelf ON book.shelf_id = book_shelf.id ORDER BY id DESC");

---