复杂的Yii SQL语句(Complex Yii SQL statement)

 我是Yii的新手，我很难将SQL查询转换为Yii Active Record语言或使用查询构建器。 
 
 我有3个表： - 帖子：id，text - 标签：id，name - Post_Tag：id_post，id_tag 
 
 我想要做的是能够选择具有用户选择的所有标签的帖子：这是有效的SQL语句，我想翻译成Yii语言： 
 
SELECT * FROM Post p INNER JOIN tags pt ON p.id=pt.post_id WHERE pt.tag_id in(10, 13) group by pt.post_id having count(distinct pt.tag_id) > 1;
 
 有人有事要帮助我吗？ 提前致谢 ！ 

I'm new to Yii and I have difficulties to translate an SQL query to Yii Active Record language or with the query builder.
 
I have 3 tables : - Post : id, text - Tag : id, name - Post_Tag : id_post, id_tag
 
What i want to do is to be able to select the posts that have all tags selected by the user : Here is the SQL statement that works and that i want to translate to Yii language :
 
SELECT * FROM Post p INNER JOIN tags pt ON p.id=pt.post_id WHERE pt.tag_id in(10, 13) group by pt.post_id having count(distinct pt.tag_id) > 1;
 
Is someone got something to help me ? thanks in advance !

原文：https://stackoverflow.com/questions/16921487