/*
 * Use [show_subsite_admin]
 */

 function show_subsite_admin_func( $atts ) {
    $a = shortcode_atts( array(
        'exclude' => ''
    ), $atts );

    $sites = wp_get_sites( array( 'limit' => 5000 ) );

    $html .= '<table width="100%" cellspacing="0" cellpadding="0">';
    $html .= '<tr>';
    $html .= '<th>Site Name</th>';
    $html .= '<th>Admin</th>';
    $html .= '<th>Email</th>';
    $html .= '<th>Bio</th>';
    $html .= '<th>Avatar</th>';
    $html .= '</tr>';

    foreach( $sites as $site ) {
        if( $site['blog_id'] == 1 ) continue;
    switch_to_blog( $site['blog_id'] );
    $html .= '<tr>';
    $html .= '<td><a href="' . site_url() . '" target="_blank">' . get_bloginfo( 'name' ) . '</a></td>';
    $user = get_user_by( 'email', get_bloginfo( 'admin_email' ) );
    $html .= '<td>' . $user->display_name . '</td>';
    $html .= '<td>' . get_bloginfo( 'admin_email' ) . '</td>';
    $html .= '<td>' . $user->description . '</td>';
    $html .= '<td>' . get_avatar( get_bloginfo( 'admin_email' ) , 40) . '</td>';
    $html .= '</tr>';
    restore_current_blog();
    }
    $html .= '</table>';
    return $html;

}
add_shortcode( 'show_subsite_admin', 'show_subsite_admin_func' );