删除帖子时，我想从自定义表中删除帖子id。我试过这种方法，什么也没发生。请帮忙。

add_action(\'delete_post\', \'delete_data\');

function delete_data($post_id) {
   global $wpdb;
   $table_name = $wpdb->prefix . \'post_order\';
   if ($wpdb->get_var($wpdb->prepare("SELECT `id` FROM $table_name WHERE `pid` = %d", $post_id))) {
       $wpdb->query($wpdb->prepare("DELETE FROM $table_name WHERE `pid` = %d", $post_id));
   }
}