global $wpdb;
    $table_name ='users';
    $sql="select * from $table_name where username='".$username."' and password='".$password."'";
    $user=$wpdb->get_results($sql);

if(!empty($user)){

         echo 'success';


    }

    else{
        echo 'faliure';
    }