Get Yoast SEO meta by calling a DB

yoast-seo.php

<?php

function get_yoast_seo_category_meta_title( $object_id) {
	global $wpdb;
	
	$table_name = $wpdb->prefix . 'yoast_indexable';
	
	$result = $wpdb->get_row( $wpdb->prepare("SELECT title FROM $table_name WHERE `object_id` = '%s' AND `object_sub_type` = 'category';", $object_id), ARRAY_A );
	
	return $result['title'] ?? 'None';
}

function get_yoast_seo_category_meta_desc( $object_id) {
	global $wpdb;
	
	$table_name = $wpdb->prefix . 'yoast_indexable';
	
	$result = $wpdb->get_row( $wpdb->prepare("SELECT description FROM $table_name WHERE `object_id` = '%s' AND `object_sub_type` = 'category';", $object_id), ARRAY_A );
	
	return $result['description'] ?? 'None';
}