Mine

<?php
global $wpdb;
$linkids = $wpdb->get_results('SELECT link_id FROM wp_link2cat WHERE category_id = "1504" ORDER BY link_id');
foreach($linkids as $linkid){
    $linkurls = $wpdb->get_results('SELECT link_url FROM wp_links WHERE link_id = "$linkid->link_id" ORDER BY link_id');
    foreach($linkurls as $linkurl){
        $bloggers = $wpdb->get_results('SELECT ID, user_nicename FROM wp_users WHERE user_url = "$linkurl->link_url" ORDER BY display_name');
        foreach($bloggers as $blogger){
            $firstname = get_usermeta($blogger->ID, 'first_name');
            $lastname = get_usermeta($blogger->ID, 'last_name');
            echo '<li><a href="http://localhost/final/author/' . $blogger->user_nicename . '">' . $firstname . ' ' . $lastname . '</a></li>';
        }
    }
}
?>