WordPress count author post using id

$post = $wp_query->get_queried_object();
$author_id = $post->post_author;
$post_count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_author = '" . $author_id . "' AND post_type = 'campaigns' AND post_status = 'publish'");