我有一个自定义的“事件”帖子类型，其中有一个元键“event\\u date”

我使用以下内容检索这些帖子并按“event\\u date”进行排列

        global $wpdb;
        $today = date(\'Y/m/d\', strtotime("now"));
        $events = $wpdb->get_results("SELECT 
                                            posts.id, posts.post_title, meta.meta_value 
                                        FROM 
                                            {$wpdb->prefix}postmeta as meta
                                        LEFT JOIN 
                                            {$wpdb->prefix}posts as posts 
                                        ON 
                                            (meta.post_id = posts.id) 
                                        WHERE
                                            (meta.meta_key = \'event_date\' 
                                        AND
                                            meta.meta_value >= \'{$today}\'
                                        AND
                                            posts.post_status=\'publish\' and posts.post_date < NOW())
                                        ORDER BY 
                                            meta.meta_value
                                    ");

以上工作正常，但我只想显示特定类别的“事件”（比如类别id“5”）。如何修改查询以实现此目的？

任何帮助都将不胜感激：）

function filter_event_where( $where = \'\' ) {
    $date = date(\'Y-m-d\'); 
    $where .= " AND posts.post_date < \'".$date."\'";
    return $where;
}

add_filter( \'posts_where\', \'filter_event_where\' );
$today = date(\'Y/m/d\', strtotime("now"));
$query = new WP_Query( array(
    \'meta_key\' => \'event_date\', //used for order
    \'orderby\' => \'meta_value\', //used for order
    \'post_type\' => \'event\',
    \'meta_query\' => array(
        array(
            \'key\' => \'event_date\',
            \'value\' => $today,
            \'compare\' => \'>=\'
        )
    )
    ));
remove_filter( \'posts_where\', \'filter_event_where\' );