如果您有author_id, post_status 和cat_id 和你在一起。

global $wpdb;

$author_id = 1;

$cat_id = 1;

$post_status = \'publish\';

/*  Post Titles  */

$search_titles = $wpdb->get_col(        
                "SELECT DISTINCT post_title FROM $wpdb->posts
                LEFT JOIN $wpdb->term_relationships ON
                ($wpdb->posts.ID = $wpdb->term_relationships.object_id)
                LEFT JOIN $wpdb->term_taxonomy ON
                ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
                WHERE $wpdb->posts.post_status = \'$post_status\'
                AND $wpdb->posts.post_type = \'post\'
        AND $wpdb->posts.post_author = $author_id
                AND $wpdb->term_taxonomy.taxonomy = \'category\'
                AND $wpdb->term_taxonomy.term_id = $cat_id"        
)

<?php 
$args = array(
    \'posts_per_page\'   => -1,
    \'cat\'              => 7,
    \'orderby\'          => \'post_date\',
    \'order\'            => \'DESC\',
    \'post_type\'        => \'post\',
    \'post_status\'      => array(\'publish\', \'draft\', \'pending\' ),
    \'author\'           => 1,
); 

$postslist = get_posts( $args );
foreach ( $postslist as $post ) :
  setup_postdata( $post ); ?> 
    <div>
        <?php the_date(); ?>
        <?php the_title(); ?>   
        <?php the_excerpt(); ?>
    </div>
<?php
endforeach; 
wp_reset_postdata();
?>