stdObject stored in database. How does one convert it to usable format?

You unserialize() it.

Be aware that most WordPress functions will automatically unserialize() database content before using it. See, for example, the Used By list for maybe_unserialize(). This is by no mean an exhaustive list, I’m sure.

But if you’re retrieving data directly from the database — because there’s not a WordPress function to achieve what you need to do — you’ll need to unserialize() the results.

For example:

$x = $wpdb->get_results( '{your SQL query}' );
// $x will be a serialized string
$unserialized_results = unserialize( $x );

The example you provide actually appears to be an array of 8 stdObjects, with keys from 1 to 8 (unless I’m reading it wrong, which is definitely possible). So that array would be what’s in $unserialized_results at the end of my code snippet.