get-user-meta-macros-single-value.php

<?php

add_filter( 'jet-engine/listings/macros-list', 'jet_register_custom_macros' );

/**
 * Add new macros to default macros list
 *
 * %business_users% - macros name
 *
 */
function jet_register_custom_macros( $macros_list ) {
	$macros_list['business_users'] = 'jet_get_business_users';
	return $macros_list;
}

/**
 * Macros callback function
 */
function jet_get_business_users( $field_value ) {
	
	$users   = array();
	$post_id = get_the_ID();
	
	// You need to replace this with your actual meta key
	$meta_key = 'user-business';

	global $wpdb;

	$query = "SELECT user_id FROM $wpdb->usermeta WHERE `meta_key` = '$meta_key' AND `meta_value` = $post_id";
	$res   = $wpdb->get_results( $query, 'ARRAY_A' );

	if ( ! empty( $res ) ) {
		foreach( $res as $user ) {
			$users[] = $user['user_id'];
		}
	}

	if ( empty( $users ) ) {
		$users[] = 'not-found';
	}

	return implode( ',', $users );
}

get-user-meta-macros.php

<?php

add_filter( 'jet-engine/listings/macros-list', 'jet_register_custom_macros' );

/**
 * Add new macros to default macros list
 *
 * %business_users% - macros name
 *
 */
function jet_register_custom_macros( $macros_list ) {
	$macros_list['business_users'] = 'jet_get_business_users';
	return $macros_list;
}

/**
 * Macros callback function
 */
function jet_get_business_users( $field_value ) {
	
	$users   = array();
	$post_id = get_the_ID();
	
	// You need to replace this with your actual meta key
	$meta_key = 'user-business';

	global $wpdb;

	$query = "SELECT user_id FROM $wpdb->usermeta WHERE `meta_key` = '$meta_key' AND `meta_value` LIKE '%\"$post_id\"%'";
	$res   = $wpdb->get_results( $query, 'ARRAY_A' );

	if ( ! empty( $res ) ) {
		foreach( $res as $user ) {
			$users[] = $user['user_id'];
		}
	}

	if ( empty( $users ) ) {
		$users[] = 'not-found';
	}

	return implode( ',', $users );
}