大家,我有2个表,通过第三个相关：结构如下所示：Playlist: id, channel_id, name, date Files: id, name, duration Playlist-rel-Files: list_id, file_id我在我的应用程序中使用ActiveRecord.当我使用此类查询获取最后一个播放列表时：$pl = Playlist::find()->where(['channel_id' => $model->channel_id])->orderBy(['date' => SORT_DESC])->limit(1)->one();然后我使用这样的代码来获取与上一个播放列表相关的所有文件：$f = $...
我有一个带有parent_id外键的Comments表,该外键指向自身以启用线程注释.Comments id INT UNSIGNED NOT NULL parent_id INT UNSIGNED NULL comment TEXT NOT NULL created_time DATETIME NOT NULL最初的ActiveQuery就是这样class CommentActiveQuery extends \yii\db\ActiveQuery {public function andWhereIsNotRemoved() {return $this->andWhere(['isRemoved' => Comment::STATUS_IS_NOT_REMOVED]);}public function andWherePar...
我有两张桌子,我想参加…即营地和城市.我已经用PHP编写了这个查询…但是我想要Yii2格式的相同查询…请告诉我如何在yii2中编写这个查询… ?? 这是我的查询：SELECT DISTINCT camps.city_id, camps.state_id, cities.city_name from camps LEFT JOIN citiesON cities.state_id = camps.state_idWHERE camps.state_id = 5AND camps.status = '1'ORDER BY cities.city_name ASC解决方法: use yii\db\Query;$query = new Query(); $qu...