I have this SQL query that I would like to convert to Eloquent:

```
 $query = "(SELECT name, Heading, 'msg' as type FROM tbl_cms WHERE name LIKE '%" . 
       $keyword . "%' OR Heading LIKE '%" . $keyword ."%') 
       UNION
       (SELECT name, channel, 'topic' as type FROM  tbl_dramas WHERE name LIKE '%" . 
       $keyword . "%' OR channel LIKE '%" . $keyword ."%')";

```

My current Eloquent query looks like this:

```
$keyword = $request->get("term");
if ($keyword != '') {
    $query->where(function ($query) use ($request) {
        $query->where("name", "LIKE","%$keyword%")
            ->orWhere("Heading", "LIKE", "%$keyword%");
    });
}
return view('search', ['title' => 'search' ,'query' => $query]);

```

How can I convert it successfully?