I have two tables. Just like
----UserTable----
id user email
1 admin admin@gmail.com
2 editor editor@gmail.com
----NameTable----
name userid fullname mobile
own 1 Rahim 012314
father 1 Karim 120120
mother 1 Florin 212021
own 2 Masum 012314
father 2 Nahid 120120
mother 2 Zane 212021
How to fetch data all (Just Like name, Father, Mother, Own name) data in single query in mysql?
----Output Table----
id user email name fathername mothername
1 admin admin@gmail.com Rahim Karim Florin
2 editor editor@gmail.com Masum Nahid Zane