OpenCart 🇺🇦

$custom_field_value_data = array();

$custom_field_value_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "custom_field_value WHERE custom_field_id = '" . (int)$custom_field_id . "'");

foreach ($custom_field_value_query->rows as $custom_field_value) {
	$custom_field_value_description_data = array();

	$custom_field_value_description_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "custom_field_value_description WHERE custom_field_value_id = '" . (int)$custom_field_value['custom_field_value_id'] . "'");			

	foreach ($custom_field_value_description_query->rows as $custom_field_value_description) {
		$custom_field_value_description_data[$custom_field_value_description['language_id']] = array('name' => $custom_field_value_description['name']);
	}

	$custom_field_value_data[] = array(
		'custom_field_value_id'          => $custom_field_value['custom_field_value_id'],
		'custom_field_value_description' => $custom_field_value_description_data,
		'sort_order'                     => $custom_field_value['sort_order']
	);
}

return $custom_field_value_data;