How to refer to linked CodeIgniter table?

Question

CodeIgniter

There is such a connection

$this->db->select("*");
$this->db->from('shop_products');
$this->db->join('shop_products_lang', 'shop_products_lang.shop_products_id = shop_products.id', 'left');
return $this->db->get()->result();

How can I extract the name of a product? In Yii, for example, I would turn
$item->shop_products_lang->name
In the ignitor, I don’t understand how this constructor works.