mysql取多个表的数据,加入MySQL以获取多个表数据

I have two table user and follow. I want to write view such that it will fetch all details of particular user along with that two extra column as follower count and followee count alias.

eg. user id=11 then all details from user tables plus followcount 1 and followed count1

解决方案SELECT u.id,

u.userid,

u.name,

u.mobile,

(SELECT Count(*)

FROM follow f

WHERE f.followerid = u.userid) AS follower,

(SELECT Count(*)

FROM follow f

WHERE f.followeeid = u.userid) AS followee

FROM users u