Fetch User Meta Data

Question

Table - wp_usermeta

user_id  meta_key      meta_value
10       login_status  0  
10       active_code   3f7431e226893f16cbe44424850d00ad

I need to select user_id where login_status = 0 and active_code = 3f7431e226893f16cbe44424850d00ad

Ex: SELECT user_id FROM usermeta WHERE active_code ='3f7431e226893f16cbe44424850d00ad' and login_status='0'

Tried below query but no success.

$querystr = "
        SELECT $wpdb->usermeta.user_id, $wpdb->usermeta.meta_key
        FROM $wpdb->usermeta
        WHERE $wpdb->usermeta.meta_value = '3f7431e226893f16cbe44424850d00ad`
        AND $wpdb->usermeta.meta_value = '0' ";

How can I simply fetch the login_status value along with active_code.

Thanks

Answer 1

All of this can be done using WP_User_Query:

$users = new WP_User_Query(array(
    meta_query(
        array( 'key' => 'login_status', 'value' => '0' ),
        array( 'key' => 'active_code', 'value' => '3f7431e226893f16cbe44424850d00ad' )
    )
));

This will return a list of users that meet your requirements. Then you can get the ids like so:

$user_ids = wp_list_pluck( $users->get_results(), 'ID' );