如何使用Scala Slick编写一对多查询，返回如下内容`(Model1，Option[Seq[Model2]])`

case class Model1(id: Int, name: String)
case class Model2(id: Int, name: String, model1Id: Int)

import slick.jdbc.MySQLProfile.api._

class Model1Table(tag: Tag) extends Table[Model1](tag, "model1") {
  def id = column[Int]("id", O.PrimaryKey)
  def name = column[String]("name")
  
  def * = (id, name) <> (Model1.tupled, Model1.unapply)
}

class Model2Table(tag: Tag) extends Table[Model2](tag, "model2") {
  def id = column[Int]("id", O.PrimaryKey)
  def name = column[String]("name")
  def model1Id = column[Int]("model1_id")
  
  def * = (id, name, model1Id) <> (Model2.tupled, Model2.unapply)
  
  def model1 = foreignKey("model1_fk", model1Id, model1Table)(_.id)
  def model1Table = TableQuery[Model1Table]
}

val query = for {
  (m1, m2) <- model1Table joinLeft model2Table on (_.id === _.model1Id)
} yield (m1, m2)

val result = db.run(query.result)

val resultFuture: Future[Seq[(Model1, Option[Model2])]] = db.run(query.result)

val transformedResult: Future[Seq[(Model1, Option[Seq[Model2]])]] = resultFuture.map { rows =>
  rows.groupBy(_._1).mapValues(_.flatMap(_._2)).toSeq
}