select `brands`.*, (selectcount(*) from `vehicles` where `brands`.`id` = `vehicles`.`brand_id` and `status` =1) as `vehicles_count` from `brands` where `status` =1orderby `name` asc
select `seaters`.*, (selectcount(*) from `vehicles` where `seaters`.`id` = `vehicles`.`seater_id` and `status` =1) as `vehicles_count` from `seaters` where `status` =1orderby `number` asc