创建动态导航子菜单使用Codeigniter从数据库中选择？

CREATE TABLE navigation_menu (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    url VARCHAR(100)
);

class Navigation_model extends CI_Model {
    public function get_navigation_menu() {
        $query = $this->db->get('navigation_menu');
        return $query->result();
    }
}

class Navigation extends CI_Controller {
    public function index() {
        $this->load->model('Navigation_model');
        $data['navigation_menu'] = $this->Navigation_model->get_navigation_menu();
        $this->load->view('navigation_view', $data);
    }
}

<ul>
    <?php foreach ($navigation_menu as $menu): ?>
        <li><a href="<?php echo $menu->url; ?>"><?php echo $menu->name; ?></a></li>
    <?php endforeach; ?>
</ul>