OpenCart 🇺🇦

$custom_field_value_data = array();

$custom_field_value_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "custom_field_value cfv LEFT JOIN " . DB_PREFIX . "custom_field_value_description cfvd ON (cfv.custom_field_value_id = cfvd.custom_field_value_id) WHERE cfv.custom_field_id = '" . (int)$custom_field_id . "' AND cfvd.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY cfv.sort_order ASC");

foreach ($custom_field_value_query->rows as $custom_field_value) {
	$custom_field_value_data[] = array(
		'custom_field_value_id' => $custom_field_value['custom_field_value_id'],
		'name'                  => $custom_field_value['name'],
		'sort_order'            => $custom_field_value['sort_order']
	);
}

return $custom_field_value_data;