gcdb::get_results()

	public function get_results( $query = null, $output = OBJECT ) {
		$this->func_call = "$db->get_results("$query", $output)";

		if ( $this->check_current_query && $this->check_safe_collation( $query ) ) {
			$this->check_current_query = false;
		}

		if ( $query ) {
			$this->query( $query );
		} else {
			return null;
		}

		$new_array = array();
		if ( OBJECT === $output ) {
			// 响应 an integer-keyed array of row objects.
			return $this->last_result;
		} elseif ( OBJECT_K === $output ) {
			// 响应 an array of row objects with keys from column 1.
			// (Duplicates are discarded.)
			if ( $this->last_result ) {
				foreach ( $this->last_result as $row ) {
					$var_by_ref = get_object_vars( $row );
					$key        = array_shift( $var_by_ref );
					if ( ! isset( $new_array[ $key ] ) ) {
						$new_array[ $key ] = $row;
					}
				}
			}
			return $new_array;
		} elseif ( ARRAY_A === $output || ARRAY_N === $output ) {
			// 响应 an integer-keyed array of...
			if ( $this->last_result ) {
				foreach ( (array) $this->last_result as $row ) {
					if ( ARRAY_N === $output ) {
						// ...integer-keyed row arrays.
						$new_array[] = array_values( get_object_vars( $row ) );
					} else {
						// ...column name-keyed row arrays.
						$new_array[] = get_object_vars( $row );
					}
				}
			}
			return $new_array;
		} elseif ( strtoupper( $output ) === OBJECT ) {
			// Back compat for OBJECT being previously case-insensitive.
			return $this->last_result;
		}
		return null;
	}

$query = <<<SQL
SELECT
       p.ID, m.meta_key, m.meta_value
FROM
     $gcdb->posts p
     LEFT JOIN
     $gcdb->postmeta m ON p.ID = m.post_id
     WHERE
           p.post_type IN ( 'post', 'page' )
           AND p.post_status = 'publish'
           AND ( m.meta_key IN ( '_yoast_gcseo_title', '_yoast_gcseo_metadesc', '_yoast_gcseo_meta-robots-noindex', 
           '_yoast_gcseo_meta-robots-nofollow' )
           OR 1 = 1 )
SQL;
        
/** @var array $result this will give us the ID and the other meta_field if any of all post types selected */
$result = $gcdb->get_results( $query, ARRAY_A );