SELECT tb_article.article_name,tb_type.type_name,tb_user.user_name
FROM tb_article inner join tb_user on tb_article.userid=tb_user.user_phone
inner join tb_type on tb_article.typeid=tb_type.id;
或
SELECT a.article_name,b.type_name,c.user_name
FROM tb_user AS c LEFT JOIN (tb_article AS a LEFT JOIN tb_type AS b ON
a.typeid=b.id) ON a.userid=c.user_phone;