Query user meta for a user

query-user-meta.php

<?php
/**
 * Query user meta
 *
 * @param string|array $name_patt Meta key pattern match
 * @param int $uid User ID
 * @param string $query_suffix SQL query suffix
 *
 * @return array|null Results of query
 */
function shramee_query_user_meta( $name_patt, $uid = 0, $query_suffix = 'ORDER BY umeta_id DESC;' ) {
	if ( ! $uid ) {
		$uid = get_current_user_id();
	}

	if ( $uid ) {
		/** @var wpdb $wpdb */
		global $wpdb;

		$select = '`meta_key` as `key`, `meta_value` as `value`';
		// Escape for sql query
		$name_patt = esc_sql( $name_patt );
		if ( is_array( $name_patt ) ) {
			$name_patt = implode( "' OR `meta_key` LIKE '", $name_patt );
		}

		return $wpdb->get_results(
			"SELECT {$select} FROM {$wpdb->usermeta} " .
			"WHERE ( `meta_key` LIKE '{$name_patt}' ) AND `user_id` = {$uid} " .
			$query_suffix
		);
	}

	return [];
}