使用codeigniter和oracle从2个表中获取数据以显示在1个表中

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'oracle_hostname',
    'username' => 'oracle_username',
    'password' => 'oracle_password',
    'database' => 'oracle_database',
    'dbdriver' => 'oci8',
    // 其他配置参数...
);

class My_model extends CI_Model {
    public function get_data() {
        $query = $this->db->query("SELECT * FROM table1 JOIN table2 ON table1.id = table2.id");
        return $query->result();
    }
}

class My_controller extends CI_Controller {
    public function index() {
        $this->load->model('my_model');
        $data['result'] = $this->my_model->get_data();
        $this->load->view('my_view', $data);
    }
}

<table>
    <thead>
        <tr>
            <th>Column 1</th>
            <th>Column 2</th>
            <!-- 其他列... -->
        </tr>
    </thead>
    <tbody>
        <?php foreach ($result as $row): ?>
        <tr>
            <td><?php echo $row->column1; ?></td>
            <td><?php echo $row->column2; ?></td>
            <!-- 其他列... -->
        </tr>
        <?php endforeach; ?>
    </tbody>
</table>