php中的用户名，电子邮件或电话号码登录系统

Question

I want to build login system in PHP if user input username or email or phone number and password then user login successful

field username email and password in the wp_users table

and phone number is wp_metauser table if user enter phone number then match meta_key= phone_no and meta_value=674637388273

     field        value           comments                table
OR   email       =674637388273                            wp_users 
OR   username    =674637388273                            wp_users 
OR   meta_value  =674637388273   if phone no then         wp_metauser 
And  meta_value  = 'phone_no'     //is string             wp_metauser 
AND  Password    =********                                 wp_users 

I have a query but show error

 $query = "select * from  wp_users where ( user_login='$email' OR user_email = '$email' OR 'select * from  wp_usermeta where meta_key='phone_no' and meta_value='$email'') and user_pass='$password'";

Answer 1

Kindly see the example of inner join in w3school.com

SELECT column_name(s)
FROM table1
JOIN table2
ON table1.column_name=table2.column_name;