You dont need to loop. Since you need to get one result, you can use like this
$query = $this->db->query('SELECT name FROM my_table LIMIT 1');
$row = $query->row();
echo $row->name;
Meke sure to read the document first.
https://www.codeigniter.com/userguide3/database/examples.html