我想列出我的作者和他们最后一篇文章的标题。

ı想要样本排序

user1, title1, date=19.10.2017 > user2, title2, date=17.10.2017 > user3, title3, date=15.10.2017

<?php
global $wpdb;
$results = $wpdb->get_results( "
SELECT * FROM wpig_users 
JOIN wpig_posts ON wpig_posts.post_author = wpig_users.ID
JOIN wpig_term_relationships ON wpig_posts.ID = wpig_term_relationships.object_id WHERE  term_taxonomy_id =\'11\'
ORDER BY post_date DESC LIMIT 10"  );



foreach($results as $res) { 

    //echo $res->col1;

    echo \'<b>\';
    echo $res->display_name;
    echo \'</b> // \';
    echo $res->post_title;
    echo \'<br>\';
 }
?>

如图所示

注意：我编写的代码没有列出所有作者的最后作者。