按用户角色查询wp.com

Trying to query user comments by specific user role. The idea is to display comments by user group/user role only. The code below shows all existing user comments but doesn't filter by user roles.

$query = $wpdb->prepare( "SELECT *
            FROM $wpdb->comments c
            LEFT JOIN $wpdb->commentmeta cm ON c.comment_ID = cm.comment_id
            LEFT JOIN $wpdb->users u ON c.user_id = u.ID
            WHERE c.comment_post_ID = %s
            AND c.comment_approved = 1
            ORDER BY c.comment_ID $comment_order
            ",$post->ID);

        $comments = $wpdb->get_results($query);

I feel like I need to insert something like this into the above query

ON wp_users.ID = wp_usermeta.user_id 
WHERE wp_usermeta.meta_key = 'wp_capabilities' 
AND wp_usermeta.meta_value LIKE '%".$user_rol->roles[0]."%'