WPDB count child posts by Parent post ID

function count_child_order_c2($parent_id){
 global $wpdb;
 $table = $wpdb->prefix . "posts";
 $result = $wpdb->get_var("SELECT COUNT(*)  FROM $table WHERE post_parent = $parent_id;");
 return $result;
}