求关联查询解决方法 [ 新手入门 ]

用yii关联 如何实现

select t.id,b.s1,b.s2  from tbl_t t LEFT OUTER JOIN (select tid,sum(s1) as s1,sum(s2) as s2 from tbl_b group by tid) b on(t.id=b.tid)