$sql = "SELECT a.attr_name FROM ecs_attribute AS a, ecs_goods_attr AS ga, ecs_goods AS g WHERE a.attr_id = ga.attr_id AND g.goods_id = ga.goods_id AND g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND a.attr_id='$value'";

if($temp_name = $db->getOne($sql))

请问用thinkphp find 怎么写

一般是这样
$M3 = M("ecs_brand");
$brand = $M3->field("`brand_id`,`brand_name`")->where("brand_id=" . (int) $brand_id)->find();

这种复杂的不会写啊，求帮助