alias('wdr') ->join('work_daily wd','wd.id = wdr.work_daily_id') ->where('wdr.is_read',0) ->where('wdr.type',2) ->where('wdr.receive_user_id',$userId) ->where('wd.org_id',$orgId) ->count(); return $count; } }