how to convert wordpress query to pdo query

I just found my answer

"SELECT post_title ,post_date, display_name ,wp_users.ID, wp_users.display_name as user_nicename, COUNT(*) as count 
        FROM wp_posts, wp_users, wp_term_relationships 
        WHERE wp_posts.post_type="post" 
        AND wp_posts.post_status="publish" 
        AND wp_posts.post_author = wp_users.ID 
        AND wp_posts.ID = wp_term_relationships.object_id 
        AND wp_term_relationships.term_taxonomy_id = '10'
        GROUP BY post_author ORDER BY count DESC LIMIT 5 ;"