BuddyPress.org

Ok nevermind,
I was able to fix a few syntax errors and get this working. Here’s the code:

bp-custom

// Add meta fields upon group creation
function bp_group_meta_save ( $group_id ) {
	$blog = get_blog_details( get_current_blog_id(), true );
	
	$fields = array(
	'blog_id' => $blog->blog_id,
	'blog_path' => $blog->path,
	'blog_name' => $blog->blogname
	);
	
	foreach ( $fields as $field => $value ) {
	groups_update_groupmeta( $group_id, $field, $value );
	}
}
add_action( 'groups_created_group', 'bp_group_meta_save' );

function get_groups_by_meta ( $field, $meta_key, $meta_value ) {
	global $wpdb;
	
	if ( is_string( $meta_value) ) $meta_value = "'" . $meta_value . "'";
	
	$sql = $wpdb->prepare( "SELECT $field from {$wpdb->base_prefix}bp_groups_groupmeta WHERE meta_key='$meta_key' AND meta_value=$meta_value", OBJECT );
	$res = $wpdb->get_results( $sql );
	
	return $res;
}

// Build a list of groups with the matching blog_id value
function get_groups_by_blogid ( $blog_id = 1 ) {
	$list = get_groups_by_meta( 'group_id', 'blog_id', $blog_id );
	
	if ( count( $list ) ) {
	$res = "";
	foreach ( $list as $item ) {
	$res .= $item->group_id . ',';
	}
	return substr( $res, 0, -1);
	} else {
	return FALSE;
	}
}

groups-loop

<?php 
$current_blogid = get_current_blog_id();

if ( $current_blogid > 1) {
$groups_set = get_groups_by_blogid( $current_blogid );
( $groups_set !== FALSE ) ? $extra_args = '&include=' . $groups_set : $extra_args = '&include=-1';
}

if ( bp_has_groups( bp_ajax_querystring( 'groups' ) . $extra_args ) ) : ?>

Thanks again to @juanlopez4691