$this->db->select('messages.id, messages.id_expediteur, messages.id_destinataire, messages.message, messages.date, messages.last_user, users.username, users.avatar');
        $this->db->from('messages');
        $this->db->join('users',  'users.id = messages.id_expediteur', 'users.id = messages.id_destinataire');
        $this->db->where('messages.expediteur = 1 OR messages.id_destinataire = 1');
        $this->db->order_by('messages.id DESC');
        return $this->db->get()->result_array();
    }