有没有更好或更快速的方法来做到这一点？
如果指数
$tagsResult的
postId，您可以通过做
FETCH_GROUP，那么你就可以取下内嵌套循环抢在一定时间一定所有帖子ID标签：
$sql = " SELECt pt.idPost, 鈥� select idPost first so it鈥檚 grouped by this colt.* FROM tags t JOIN poststags pt ON t.id=pt.idTag WHERe pt.idPost IN (array of post ids)";$stmt=$db->prepare($sql);$stmt->execute();$tagsResult = $smt->fetchAll(PDO::FETCH_GROUP|PDO::FETCH_OBJ);//$tagsResult is now grouped by postId//see https://stackoverflow.com/questions/5361716/is-there-a-way-to-fetch-associative-array-grouped-by-the-values-of-a-specified-cforeach($postsResult as &$post) { if(isset($tagsResult[$post->id])) { $post->tags = $tagsResult[$post->id]; } else { $post->tags = array(); } }
