如何将查询从MySQL传递到Laravel?

我在MySQL中的查询 SELECT TIMESTAMPDIFF(YEAR,birthdate,CURDATE()) AS age FROM employe where month(birthdate)=month(NOW())

从出生之日起,获得本月的生日加上您的年龄。

在拉拉维尔:

public function index()

{

    {


     $bird = DB::table('employe')

    ->whereraw('TIMESTAMPDIFF(YEAR,birthdate,CURDATE()) AS age FROM employe where month(birthdate)=month(NOW())') 

    ->select('employe.*')

    ->get();
    return response()->json(
        $bird->toArray()
    );

但它会给我带来错误

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS edad FROM employe where month(birthdate)=month(NOW())' at line 1 (SQL: select `employe`.* from `employe` where TIMESTAMPDIFF(YEAR,birthdate,CURDATE()) AS age FROM employe where month(birthdate)=month(NOW()))