$query = $this->db->get('users');
foreach ($query->result() as $row)
{
    echo $row->username;
}