php - 合并mysql中的依赖查询

Question

我有两个单独的查询。

1)

SELECT Email, UserId, FirstName, LastName FROM user WHERE 1;

2)

      SELECT COUNT(PostId) as userTextCount
        FROM posts 
  INNER JOIN user ON user.UserID =  posts.PostedAsId
       WHERE UserId='$uid'
         AND PostedAs='USER'
         AND PostType='text';

我想将这两个查询合并为一个。问题是在第二个查询中有一个名为 $uid 的变量，我将在运行第一个查询后得到该变量。我们可以通过不需要该变量的方式来组合这两个查询吗？如果您需要更多说明，请告诉我。

谢谢。

Answer 1

SELECT Email, UserID, FirstName, LastName, count(*) as userTextCount
FROM user INNER JOIN posts ON posts.PostedAsId = user.UserID and PostedAs = 'USER'
  and PostType = 'text'
WHERE 1
GROUP BY Email, UserID, FirstName, LastName