global $wpdb;
$results = $wpdb->get_results( "SELECT post_id from $wpdb->postmeta WHERE meta_key = 'my_key' AND meta_value = 'my_value'", ARRAY_A );
<input class="text-input" name="user_school" type="text" id="user_school" value="<?php the_author_meta( 'user_school', $current_user->ID ); ?>" />
update_user_meta( $current_user->ID, 'user_school', esc_attr( $_POST['user_school'] ) );